Avatar for Username

Sykje yn Support

Mij stipescams. Wy sille jo nea freegje in telefoannûmer te beljen, der in sms nei ta te stjoeren of persoanlike gegevens te dielen. Meld fertochte aktiviteit mei de opsje ‘Misbrûk melde’.

Mear ynfo

Dizze konversaasje is argivearre. Stel in nije fraach as jo help nedich hawwe.

Mailmerge not working

  • 1 antwurd
  • 1 hat dit probleem
  • 7 werjeftes
  • Lêste antwurd fan 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.
Keppele skermôfbyldingen

Alle antwurden (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.