vanna
03-19-2003, 10:14 AM
I am creating batch "mail merge" emails. The data is coming from our own software (not a database such as Access). We have multiple fields which could contain the piece of information I need to complete my sentence with the merged data. Is there a way to compare the 2 sets of data for blank or existence and select which one to merge in?
Within print letters I can do this with an IF-statement in Microsoft Word, but I cannot figure out how to do it in my HTML email.
Ex: {IF {MERGEFIELD COMPANY} = "C" "{MERGEFIELD CONTACT NAME}"}{IF {MERGEFIELD COMPANY} = "" "{MERGEFIELD CUSTOMERNAME}"}
Within print letters I can do this with an IF-statement in Microsoft Word, but I cannot figure out how to do it in my HTML email.
Ex: {IF {MERGEFIELD COMPANY} = "C" "{MERGEFIELD CONTACT NAME}"}{IF {MERGEFIELD COMPANY} = "" "{MERGEFIELD CUSTOMERNAME}"}