Where did you install Firefox from? Help Mozilla uncover 3rd party websites that offer problematic Firefox installation by taking part in our campaign. There will be swag, and you'll be featured in our blog if you manage to report at least 10 valid reports!

搜尋 Mozilla 技術支援網站

防止技術支援詐騙。我們絕對不會要求您撥打電話或發送簡訊,或是提供個人資訊。請用「回報濫用」功能回報可疑的行為。

Learn More

Mailmerge TO {{Email}} not working but Body variables work.

  • 3 回覆
  • 1 有這個問題
  • 14 次檢視
  • 最近回覆由 Toad-Hall

more options

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

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

由 glw714 於 修改

被選擇的解決方法

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.

從原來的回覆中察看解決方案 👍 0

所有回覆 (3)

more options

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.

more options

選擇的解決方法

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.

由 glw714 於 修改

more options

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.