I have a list of 200+ e-mail list. Some of them have First Name, some of them have Last Name and the most of them have both. Where there is neither First Name nor the Last Name nor both, I entered "Hello" as First name and "there" as Last Name. Now, when I use mail merge add on, in order to have personalized e-mail, I am using Hello {{FirstName}} {{LastName}} but this has a side effect of "Hello Hello" where ever First Name entry is "Hello". I tried {{Hello|if|}} and it inserts blank for the second Hello. Now I want to print the First Name where entry is not Hello. How would I do that? I have tried {{FirstName|Hello||FirstName}} and I get "FirstName" printed in the output instead of entry from the file.
I also have used Hello {{FirstName|Hello||FirstName}} and it produces "Hello FirstName" as result.
***************************************************************
I also looked at https://addons.mozilla.org/en-us/thunderbird/addon/mail-merge/
Variable: {{name|if|then}}
If the value of the field name equals if, then the variable will be replaced by then.
Variable: {{name|if|then|else}}
If the value of the field name equals if, then the variable will be replaced by then, else by else.
Variable: {{name|*|if|then|else}} (contains) (regexp)
If the value of the field name contains if, then the variable will be replaced by then, else by else.
************************************************************
File Format: MassMail.csv
FirstName,LastName,e-mail
John,Doe,john.Doe@someone.com
Hello,Smith,hsmith@xtz.com
Desired output:
Hello John Doe
Hello Smith
I also have used Hello {{FirstName|Hello||FirstName}} and it produces "Hello FirstName" as result.
***************************************************************
I also looked at https://addons.mozilla.org/en-us/thunderbird/addon/mail-merge/
Variable: {{name|if|then}}
If the value of the field name equals if, then the variable will be replaced by then.
Variable: {{name|if|then|else}}
If the value of the field name equals if, then the variable will be replaced by then, else by else.
Variable: {{name|*|if|then|else}} (contains) (regexp)
If the value of the field name contains if, then the variable will be replaced by then, else by else.
************************************************************
File Format: MassMail.csv
FirstName,LastName,e-mail
John,Doe,john.Doe@someone.com
Hello,Smith,hsmith@xtz.com
Desired output:
Hello John Doe
Hello Smith