Monday, October 07, 2013

How to merge mails with Firefox?

Mail Merge for Firefox 插件下载
https://addons.mozilla.org/en-us/thunderbird/addon/mail-merge/
Mail Merge:
If you want to send a mail to multiple recipients, there are three common problems: First you can't personalize the mail. Second you can't send a mail to more than 25, 100, ... recipients at once. Third the recipients should not see the other recipients.

Mail Merge solves these problems by creating one single mail for each recipient from a draft!

Step by Step: (Address Book)
Screenshots: Draft Message | Mail Merge Dialog
  1. Create a New Message ("File -> New -> Message")
  2. Add the Recipients to To
  3. Add the Recipients to Cc (optional) (variables are supported)
  4. Add the Recipients to Bcc (optional) (variables are supported)
  5. Add the Subject (variables are supported)
  6. Add the Body (variables are supported)
  7. Add the Attachments (optional)
  8. Click "File -> Mail Merge"
  9. Select "Address Book" and check "Deliver Mode" and "Format"
  10. Add (individual) Attachments (optional) (variables are supported)
  11. Check "Start", "Stop" and "Pause" (optional)
  12. Click "OK"
The Draft Message is saved as Template in your Current Account and for each Recipient a New Message is automagically saved in your Outbox ("Local Folders -> Outbox"). Ready for Delivery: "File -> Send Unsent Messages"

Step by Step: (CSV)
Screenshots: Draft Message | Draft Message | Mail Merge Dialog
  1. Create a New Message ("File -> New -> Message")
  2. Add the Variable(s) to To, e.g.: {{Email}} or {{FirstName}} {{LastName}} <{{Email}}>
  3. Add the Recipients to Cc (optional) (variables are supported)
  4. Add the Recipients to Bcc (optional) (variables are supported)
  5. Add the Subject (variables are supported)
  6. Add the Body (variables are supported)
  7. Add the Attachments (optional)
  8. Click "File -> Mail Merge"
  9. Select "CSV" and check "Deliver Mode" and "Format"
  10. Add (individual) Attachments (optional) (variables are supported)
  11. Select "Filename" and check "Character Set", "Field Delimiter" and "Text Delimiter"
  12. Check "Start", "Stop" and "Pause" (optional)
  13. Click "OK"
The Draft Message is saved as Template in your Current Account and for each Recipient a New Message is automagically saved in your Outbox ("Local Folders -> Outbox"). Ready for Delivery: "File -> Send Unsent Messages"

Attachments:
You can add Attachments in the Mail Merge Dialog, e.g.:
Attachments: {{Attachment}}
Attachments: C:\{{Attachment}}
Attachments: C:\PDF\{{Attachment}}
Attachments: C:\PDF\{{Attachment}},C:\PDF\{{FirstName}}-{{LastName}}.pdf

Batch:
Start: Number of First Message (optional)
Stop: Number of Last Message (optional)
Pause: Pause between Messages in Seconds (optional) (variables are supported)

Character Set:
Character Sets Supported by Thunderbird
Windows-1252 (Windows)
UTF-8 (Linux & Mac)
备注:在从Excel整理存为csv文档后,要用记事本打开,修改编码为ITF-8,再另保存。否则会出现字符集错误的提示。

Date:
Send Later & Mail Merge

Variable: {{name}}
The variable will be replaced by the value of the field name, e.g.:
{{FirstName}}: the variable will be replaced by the value of the field FirstName
{{LastName}}: the variable will be replaced by the value of the field LastName
{{Email}}: the variable will be replaced by the value of the field Email

Variable: {{name|if|then}}
If the value of the field name equals if, then the variable will be replaced by then.

Variable: {{name|if|then|else}}
If the value of the field name equals if, then the variable will be replaced by then, else by else.

Variable: {{name|*|if|then|else}} (contains) (regexp)
If the value of the field name contains if, then the variable will be replaced by then, else by else.

Variable: {{name|^|if|then|else}} (begins with) (regexp)
If the value of the field name begins with if, then the variable will be replaced by then, else by else.

Variable: {{name|$|if|then|else}} (ends with) (regexp)
If the value of the field name ends with if, then the variable will be replaced by then, else by else.

Variable: {{name|==|if|then|else}} (equal to) (number)
If the value of the field name is equal to if, then the variable will be replaced by then, else by else.

Variable: {{name|>|if|then|else}} (greater than) (number)
If the value of the field name is greater than if, then the variable will be replaced by then, else by else.

Variable: {{name|>=|if|then|else}} (greater than or equal to) (number)
If the value of the field name is greater than or equal to if, then the variable will be replaced by then, else by else.

Variable: {{name|<|if|then|else}} (less than) (number)
If the value of the field name is less than if, then the variable will be replaced by then, else by else.

Variable: {{name|<=|if|then|else}} (less than or equal to) (number)
If the value of the field name is less than or equal to if, then the variable will be replaced by then, else by else.

Address Book:
Addressbook Properties Supported by Thunderbird
{{FirstName}}
{{LastName}}
{{DisplayName}}
{{NickName}}
{{PrimaryEmail}}
{{HomePhone}}
{{WorkPhone}}
{{FaxNumber}}
{{PagerNumber}}
{{CellularNumber}}
{{HomeAddress}}
{{HomeCity}}
{{HomeState}}
{{HomeZipCode}}
{{HomeCountry}}
{{WorkAddress}}
{{WorkCity}}
{{WorkState}}
{{WorkZipCode}}
{{WorkCountry}}
{{Company}}
{{BirthDay}}
{{BirthMonth}}
{{BirthYear}}
{{Custom1}}
{{Custom2}}
{{Custom3}}
{{Custom4}}
{{Notes}}


Address Book:
MoreFunctionsForAddressBook
{{MFFABcustom1}}
{{MFFABcustom2}}
{{MFFABcustom3}}
{{MFFABcustom4}}
{{MFFABcustom5}}
{{MFFABcustom6}}
{{MFFABcustom7}}
{{MFFABcustom8}}
{{MFFABcustom9}}
{{MFFABcustom10}}
{{MFFABemail1}}
{{MFFABemail2}}
{{MFFABemail3}}
{{MFFABemail4}}
{{MFFABemail5}}
{{AnniversaryDay}}
{{AnniversaryMonth}}
{{AnniversaryYear}}


CSV:
Character Sets Supported by Thunderbird | Comma-separated values
records are separated by line breaks (\r, \n, \r\n)
fields are separated by field delimiters (comma, semicolon, colon, tab)
fields may be enclosed within text delimiters (double quote, single quote, none)
fields with embedded line breaks must be enclosed within text delimiters
fields with embedded field delimiters must be enclosed within text delimiters
fields with embedded text delimiters must be enclosed within text delimiters
embedded text delimiters must be doubled
first record must contain columnnames


CSV: (Example)
FirstName,LastName,Sex,Email,Attachment
John,Doe,m,john.doe@example.com,C:\MyFile.pdf


Error Message: (Check the Filename)
Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [nsIFile.initWithPath]

Error Message: (Check the Filename)
Component returned failure code: 0x80520012 (NS_ERROR_FILE_NOT_FOUND) [nsIFileInputStream.init]

Error Message: (Check the Character Set)
Component returned failure code: 0x80500001 [nsIConverterInputStream.init]

Error Message: (Check the Character Set)
Component returned failure code: 0x8050000e [nsIConverterInputStream.readString]

Error Message: (Check the Character Set)
Component returned failure code: 0x8050000e (NS_ERROR_ILLEGAL_INPUT) [nsIConverterInputStream.readString]

Error Message: (Check the Body)
Component returned failure code: 0x80004002 (NS_NOINTERFACE) [nsIHTMLEditor.rebuildDocumentFromSource]

Bug:
Mail Merge does not support LDAP

Debug:
View Log Messages in the Error Console ("Tools -> Error Console")


No comments: