Avatar for Username

Cerca nel supporto

Attenzione alle mail truffa. Mozilla non chiederà mai di chiamare o mandare messaggi a un numero di telefono o di inviare dati personali. Segnalare qualsiasi attività sospetta utilizzando l'opzione “Segnala abuso”.

Ulteriori informazioni

Questa discussione è archiviata. Inserire una nuova richiesta se occorre aiuto.

Mailmerge not working

  • 1 risposta
  • 1 ha questo problema
  • 7 visualizzazioni
  • Ultima risposta di 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.
Immagini allegate

Tutte le risposte (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.