Mailmerge TO {{Email}} not working but Body variables work.
I installed mailmerge on Thunderbird version 52.7.0 (32-bit) and am trying to test it. If I select myself from an address book and put Hello {{FirstName}} in the body, the email is sent when I use mailmerge. I get the green progress bar and the email shows up in my inbox.
However if I put {{Email}} or <{{Email}}> in the TO field, I don't get a green progress bar and nothing shows up in my inbox. Note I have tried variations like send later and draft. Nothing shows up in outbox or draft local folders I have tried both an address book and a csv.
Update: I exported the address book and discovered the correct name is {{PrimaryEmail}} which works in the body but not in the TO field.
P.S. I tried to upload an image to clarify what the field looks like, but it never stopped loading. it is only a 53kb jpeg
Modified by glw714
Chosen solution
I was able to get the csv version working after I realized that Excel SaveAs CSV does not delimit the text. It only puts in the commas. It seems that most examples on the Web use cvs files.
As for the Address Book I was careful to select a test address book so the drafts would be limited. I gave up on getting to work with email or Email or PreferredEamil.
Read this answer in context 👍 0All Replies (3)
If you select an address book, then you must be certain that you want an email to go out to everyone in that address book. It may be best to create a new address which is only used for the Mail Merge. You can edit the address book to add or remove contacts as required. Please note, selecting an address book means every contact written in that selected address book must have a valid email address in the 'Email' field. Else it will fail.
This is also true with a .csv file. All column headers must be identical to the ones you use in the email template. To use {{Email}} in template email, the column header in .csv file must be exactly the same: Email
I would recommend that you use the 'Send Later' option as this will put all the individual emails into the 'Outbox' so you can check them.
See example images as guide.
Chosen Solution
I was able to get the csv version working after I realized that Excel SaveAs CSV does not delimit the text. It only puts in the commas. It seems that most examples on the Web use cvs files.
As for the Address Book I was careful to select a test address book so the drafts would be limited. I gave up on getting to work with email or Email or PreferredEamil.
Modified by glw714
I'm also having issues after further testing with address bok option. I noticed that info on the addon webpage mentions a known bug with ldap. Perhaps this is the issue. Exporting address book and using as .csv file works perfectly ok.