Mail Merge
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.
所有回覆 (1)
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.