ThunderBird - Mail Merge Add-On help needed.

yugpatel

Senior member
Feb 28, 2001
506
0
76
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
 

yugpatel

Senior member
Feb 28, 2001
506
0
76
Never mind, after some trial and error and logical thinking, the following works:
Hello {{FirstName|Hello||{{FirstName}}}} {{LastName|there||{{LastName}}}},

I had to use {{FirstName}} instead of FirstName as "else".