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

This thread was archived. Please ask a new question if you need help.

Mailmerge not working

  • 1 reply
  • 1 has this problem
  • 7 views
  • Last reply by Matt

Niall Walsh
Niall Walsh
more options

Hi - I've downloaded the add-on for sending a mail merge.

I've created a speadsheet with two headings one 'Name' one 'Email' this had been saved as a CSV (comma delimited). See 'attachment 1'.

I go in and set-up the mail merge withing the email tab, see 'attachment 2'.

I then select the mail merge tab via the file section and select my spreadsheet which I've created. See 'attachment 3'.

I then click Ok to send. Which it trys to do with the box popping up as seen in 'attachment 4', however, nothing happens?!?!? Nothing appears in any of the inboxes.

Can anybody help? I've been trying to sort this for a while now, have changed different formats of spreadsheet and even explored the addess book option. All to no avail.

Really appreciate any help.

Niall.

Hi - I've downloaded the add-on for sending a mail merge. I've created a speadsheet with two headings one 'Name' one 'Email' this had been saved as a CSV (comma delimited). See 'attachment 1'. I go in and set-up the mail merge withing the email tab, see 'attachment 2'. I then select the mail merge tab via the file section and select my spreadsheet which I've created. See 'attachment 3'. I then click Ok to send. Which it trys to do with the box popping up as seen in 'attachment 4', however, nothing happens?!?!? Nothing appears in any of the inboxes. Can anybody help? I've been trying to sort this for a while now, have changed different formats of spreadsheet and even explored the addess book option. All to no avail. Really appreciate any help. Niall.
Attached screenshots

All Replies (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

I see your probable issue in the first image. You are using Excel.

Open the file in Windows notepad. Select File > save as. Change the file "Encoding" to Unicode from ANSI Save the file.

Try again.

Or perhaps the merge allows you to change the unicode default to ANSI for the import file (I just don't use the addon, so I must guess)

For reasons only Microsoft would comprehend their office products never made the move to Unicode back in the XP time frame, so while the operating system went unicode with XP, office did not. I think in the current release finally made the leap, or part of it. This is never more obvious that when you open a unicode text CSV in excel, it wants to "import" it instead of open it. Then turns it in to a steaming pile. I find libreoffice ideal for working with CSV files as they do unicode natively and it is free software.