このアドオンについて
Description:
If you want to send a message to multiple recipients, there are a few common problems:
1) When you add the recipients in the To field, the recipients will see each other. (You can work around this problem by adding the recipients in the Bcc field.)
2) Most email providers limit the number of recipients in the To / Cc / Bcc field. (You can work around this problem by creating multiple messages.)
3) You can not personalize the message. (You can not work around this problem.)
You can work around some of these problems, but especially the last problem can not be solved without creating individual messages. Of course there are third party services, that help you to send newsletters; but you have to trust them.
Mail Merge solves these problems by creating individual messages for each recipient from a draft message - locally on your computer without the need to trust third party services!
Step by Step: (Address Book)
Screenshots: Draft Message | Mail Merge Dialog
Step by Step: (CSV)
Screenshots: Draft Message | Draft Message | Mail Merge Dialog
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
Address Book:
MoreFunctionsForAddressBook
Cardbook:
Cardbook
Cardbook: (Address)
Cardbook
Cardbook: (Types)
Cardbook
You can use the configured "Types" in the "Cardbook Configuration" as a first paramter for the properties address, email, impp, phone and url. For example:
You can use a number as a second paramter for the properties address, email, impp, phone and url - in case you have multiple entries. For example:
CSV:
Comma-separated values
CSV: (Example)
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)
Connections:
Mail Merge supports multiple concurrent connections:
extensions.mailmerge.connections
Custom Headers: (Thunderbird 38+)
Mail Merge supports Custom Headers:
mail.compose.other.header
Debug:
View Log Messages in the Error Console ("Tools -> Error Console")
Line Break:
Thunderbird uses a HTML editor internally. You can use <br> for a line break.
Send Later:
Mail Merge supports Send Later:
User Guide
Error Message: (Check the Filename)
Error Message: (Check the Filename)
Error Message: (Check the Character Set)
Error Message: (Check the Character Set)
Error Message: (Check the Character Set)
Error Message: (Check the Body)
Bug:
Mail Merge does not support LDAP
Donation:
Please support the development of Mail Merge with a donation (PayPal): 5 Euro | 10 Euro | 15 Euro | 25 Euro
If you want to send a message to multiple recipients, there are a few common problems:
1) When you add the recipients in the To field, the recipients will see each other. (You can work around this problem by adding the recipients in the Bcc field.)
2) Most email providers limit the number of recipients in the To / Cc / Bcc field. (You can work around this problem by creating multiple messages.)
3) You can not personalize the message. (You can not work around this problem.)
You can work around some of these problems, but especially the last problem can not be solved without creating individual messages. Of course there are third party services, that help you to send newsletters; but you have to trust them.
Mail Merge solves these problems by creating individual messages for each recipient from a draft message - locally on your computer without the need to trust third party services!
Step by Step: (Address Book)
Screenshots: Draft Message | Mail Merge Dialog
- Create a New Message ("File -> New -> Message")
- Add the Recipients to To
- Add other Recipients to Cc (optional) (variables are supported)
- Add other Recipients to Bcc (optional) (variables are supported)
- Add the Subject (variables are supported)
- Add the Body (variables are supported)
- Add the Attachments (optional)
- Click "File -> Mail Merge"
- Select "Address Book" and check "Deliver Mode"
- Add (individual) Attachments (optional) (variables are supported)
- Check "Start", "Stop" and "Pause" (optional)
- Click "OK"
Step by Step: (CSV)
Screenshots: Draft Message | Draft Message | Mail Merge Dialog
- Create a New Message ("File -> New -> Message")
- Add the Variable(s) to To, e.g.: {{Email}} or {{FirstName}} {{LastName}} <{{Email}}>
- Add other Recipients to Cc (optional) (variables are supported)
- Add other Recipients to Bcc (optional) (variables are supported)
- Add the Subject (variables are supported)
- Add the Body (variables are supported)
- Add the Attachments (optional)
- Click "File -> Mail Merge"
- Select "CSV" and check "Deliver Mode"
- Add (individual) Attachments (optional) (variables are supported)
- Select "Filename" and check "Character Set", "Field Delimiter" and "Text Delimiter"
- Check "Start", "Stop" and "Pause" (optional)
- Click "OK"
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}}
{{SecondEmail}}
{{HomePhone}}
{{WorkPhone}}
{{FaxNumber}}
{{PagerNumber}}
{{CellularNumber}}
{{HomeAddress}}
{{HomeAddress2}}
{{HomeCity}}
{{HomeState}}
{{HomeZipCode}}
{{HomeCountry}}
{{BirthDay}}
{{BirthMonth}}
{{BirthYear}}
{{JobTitle}}
{{Department}}
{{Company}}
{{WorkAddress}}
{{WorkAddress2}}
{{WorkCity}}
{{WorkState}}
{{WorkZipCode}}
{{WorkCountry}}
{{WebPage1}}
{{WebPage2}}
{{Custom1}}
{{Custom2}}
{{Custom3}}
{{Custom4}}
{{Notes}}
{{_GoogleTalk}}
{{_AimScreenName}}
{{_Yahoo}}
{{_Skype}}
{{_QQ}}
{{_MSN}}
{{_ICQ}}
{{_JabberId}}
{{_IRC}}Address Book:
MoreFunctionsForAddressBook
{{MFFABcustom1}}
{{MFFABcustom2}}
{{MFFABcustom3}}
{{MFFABcustom4}}
{{MFFABcustom5}}
{{MFFABcustom6}}
{{MFFABcustom7}}
{{MFFABcustom8}}
{{MFFABcustom9}}
{{MFFABcustom10}}
{{MFFABemail1}}
{{MFFABemail2}}
{{MFFABemail3}}
{{MFFABemail4}}
{{MFFABemail5}}
{{AnniversaryDay}}
{{AnniversaryMonth}}
{{AnniversaryYear}}Cardbook:
Cardbook
{{dirPrefId}}
{{cardurl}}
{{etag}}
{{updated}}
{{deleted}}
{{created}}
{{lastname}}
{{firstname}}
{{othername}}
{{prefixname}}
{{suffixname}}
{{fn}}
{{nickname}}
{{bday}}
{{gender}}
{{adr}}
{{tel}}
{{email}}
{{mailer}}
{{tz}}
{{geo}}
{{title}}
{{role}}
{{agent}}
{{org}}
{{categories}}
{{note}}
{{prodid}}
{{sortstring}}
{{uid}}
{{rev}}
{{url}}
{{version}}
{{class1}}
{{key}}
{{impp}}
{{others}}
{{photo}}
{{value}}
{{localURI}}
{{URI}}
{{extension}}
{{logo}}
{{value}}
{{localURI}}
{{URI}}
{{extension}}
{{sound}}
{{value}}
{{localURI}}
{{URI}}
{{extension}}
{{kind}}
{{member}}
{{dispn}}
{{dispadr}}
{{disphomeadr}}
{{dispworkadr}}
{{disptel}}
{{disphometel}}
{{dispworktel}}
{{dispcelltel}}
{{dispemail}}
{{disphomeemail}}
{{dispworkemail}}
{{dispimpp}}
{{dispurl}}
{{pgname}}
{{pg}}Cardbook: (Address)
Cardbook
{{adr}}
{{adrpostoffice}}
{{adrextended}}
{{adrstreet}}
{{adrlocality}}
{{adrregion}}
{{adrpostalcode}}
{{adrcountry}}Cardbook: (Types)
Cardbook
You can use the configured "Types" in the "Cardbook Configuration" as a first paramter for the properties address, email, impp, phone and url. For example:
{{adr#home}}
{{adr#work}}
{{email#home}}
{{email#work}}
{{tel#home}}
{{tel#work}}
{{tel#cell}}You can use a number as a second paramter for the properties address, email, impp, phone and url - in case you have multiple entries. For example:
{{email#home#0}}
{{email#home#1}}
{{email#home#2}}CSV:
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 columnnamesCSV: (Example)
FirstName,LastName,Sex,Email,Attachment
John,Doe,m,john.doe@example.com,C:\MyFile.pdfAttachments:
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)
Connections:
Mail Merge supports multiple concurrent connections:
extensions.mailmerge.connections
Custom Headers: (Thunderbird 38+)
Mail Merge supports Custom Headers:
mail.compose.other.header
Debug:
View Log Messages in the Error Console ("Tools -> Error Console")
Line Break:
Thunderbird uses a HTML editor internally. You can use <br> for a line break.
Send Later:
Mail Merge supports Send Later:
User Guide
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
Donation:
Please support the development of Mail Merge with a donation (PayPal): 5 Euro | 10 Euro | 15 Euro | 25 Euro