Avatar for Username

搜尋 Mozilla 技術支援網站

防止技術支援詐騙。我們絕對不會要求您撥打電話或發送簡訊，或是提供個人資訊。請用「回報濫用」功能回報可疑的行為。

了解更多

此討論串已被封存。 如果您有需要幫助，請新增一個新問題

Mailmerge not working

  • 1 回覆
  • 1 有這個問題
  • 7 次檢視
  • 最近回覆由 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.
附加的畫面擷圖

所有回覆 (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.