Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Mail Merge

  • 1 reply
  • 0 have this problem
  • Last reply by Matt

ellicombe
ellicombe
more options

Have had no problem over the years sending out up to 250 personalised emails at a time, until today! Using data from a Microsoft Excel spreadsheet I used to fill in the "To" field - {{Forename}} {{Surname}} <{{E-mail Address}}> - in order to end up with, for example - Joseph Bloggs <jobloggs@xxxxxxx.com>, perfect. Today filling in the "To" field in the same way it converts to - Joseph Bloggs <"\"jobloggs"@xxxxxxx.com> . The email of course is rejected. If I just fill in the "To" field simply as - {{E-mail Address}} - it will convert correctly to -jobloggs@xxxxxxx.com. Any answers???

Cheers, Graham.

Have had no problem over the years sending out up to 250 personalised emails at a time, until today! Using data from a Microsoft Excel spreadsheet I used to fill in the "To" field - {{Forename}} {{Surname}} <{{E-mail Address}}> - in order to end up with, for example - Joseph Bloggs <jobloggs@xxxxxxx.com>, perfect. Today filling in the "To" field in the same way it converts to - Joseph Bloggs <"\"jobloggs"@xxxxxxx.com> . The email of course is rejected. If I just fill in the "To" field simply as - {{E-mail Address}} - it will convert correctly to -jobloggs@xxxxxxx.com. Any answers??? Cheers, Graham.

All Replies (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

Mail merge is supported by its author using the email address on the download page. https://addons.thunderbird.net/en-US/thunderbird/addon/mail-merge/

I would guess it is the typical mess Excel makes of Text. Very recent versions use Unicode, something windows has used since XP, but Excel versions more than a couple of years old use ANSI and the results of CSV coming out of Excel are therefore somewhat wonky on most occasions as these versions of Excel do not handle Unicode well at all.

Helpful?

Ask a question

You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.