Important Notice: We're experiencing email notification issues. If you've posted a question in the community forums recently, please check your profile manually for responses while we're working to fix this.

On Monday the 3rd of March, around 5pm UTC (9am PT) users may experience a brief period of downtime while one of our underlying services is under maintenance.

Avatar for Username

Rechercher dans l’assistance

Évitez les escroqueries à l’assistance. Nous ne vous demanderons jamais d’appeler ou d’envoyer un SMS à un numéro de téléphone ou de partager des informations personnelles. Veuillez signaler toute activité suspecte en utilisant l’option « Signaler un abus ».

En savoir plus

Ce sujet de discussion a été archivé. Veuillez poser une nouvelle question si vous avez besoin d’aide.

Mailmerge not working

  • 1 réponse
  • 1 a ce problème
  • 7 vues
  • Dernière réponse par 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.
Captures d’écran jointes

Toutes les réponses (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.