Bienvenido a Complementos Thunderbird.
Añade funciones y estilos extra para hacer tu propio Thunderbird.
Cerrar¿Eres una persona dinámica?
Revisa nuestro sitio sobre complementos para dispositivos móviles.
Cerrar
Mail Merge 7.4.0
por Alexander Bergmann
Create and Save or Send Multiple Individual and Personalized Messages from a Draft
Acerca de este complemento
Mail Merge 6.1.0 is fully compatible with Thunderbird 68!
Thunderbird 78:
Mail Merge 7.4.0 is fully compatible with Thunderbird 78!
Variable(s) in the To field in Thunderbird 78:
You must hit "Enter" or "Tab" once you have added the variable(s) in the To field. This change is caused by the new "pills" in Thunderbird 78.
Donation:
Converting Mail Merge from a "Legacy Extension" to a "MailExtension Experiment" was hard work and took a lot of time. Please show your appreciation with a donation, thanks!
5 Euro | 10 Euro | 15 Euro | 20 Euro | 25 Euro
5 Dollar | 10 Dollar | 15 Dollar | 20 Dollar | 25 Dollar
----------------------------------------------------------------------------------------------------
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 cannot personalize the message. (You cannot work around this problem.)
You can work around some of these problems, but especially the last problem cannot 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 | Draft Message | Draft Message | Mail Merge Dialog | Preview Message Dialog
- Create a New Message ("File -> New -> Message")
- Add the Recipients to To or add the Variable(s) to To, e.g.: {{PrimaryEmail}} or {{FirstName}} {{LastName}} <{{PrimaryEmail}}>
- 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 (global) 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: (CardBook)
Screenshots: Draft Message | Draft Message | Draft Message | Mail Merge Dialog | Preview Message Dialog
- Create a New Message ("File -> New -> Message")
- Add the Recipients to To or 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 (global) Attachments (optional)
- Click "File -> Mail Merge"
- Select "CardBook" 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 | Preview File Dialog | Preview Message 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 (global) Attachments (optional)
- Click "File -> Mail Merge"
- Select "CSV" as "Source" and check "Deliver Mode"
- Add (individual) Attachments (optional) (variables are supported)
- Select the "File" and check "Character Set", "Field Delimiter" and "Text Delimiter"
- Check "Start", "Stop" and "Pause" (optional)
- Click "OK"
Step by Step: (JSON)
Screenshots: Draft Message | Draft Message | Mail Merge Dialog | Preview File Dialog | Preview Message 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 (global) Attachments (optional)
- Click "File -> Mail Merge"
- Select "JSON" as "Source" and check "Deliver Mode"
- Add (individual) Attachments (optional) (variables are supported)
- Select the "File"
- Check "Start", "Stop" and "Pause" (optional)
- Click "OK"
Step by Step: (Spreadsheet)
Screenshots: Draft Message | Draft Message | Mail Merge Dialog | Preview File Dialog | Preview Message 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 (global) Attachments (optional)
- Click "File -> Mail Merge"
- Select "Spreadsheet" as "Source" and check "Deliver Mode"
- Add (individual) Attachments (optional) (variables are supported)
- Select the "File" and check "Sheet Name"
- Check "Start", "Stop" and "Pause" (optional)
- Click "OK"
----------------------------------------------------------------------------------------------------
Tutorials: (External)
Chris Bryson has published two videos:
How to Mail Merge with Thunderbird
Mail Merge Attachments with Thunderbird Email
Raffael Herrmann has published a guide (German):
Serienmails mit Thunderbird erstellen
----------------------------------------------------------------------------------------------------
Deliver Mode:
Mail Merge supports "Save as Draft", "Send Later" (default) and "Send Now" as "Deliver Mode" for the individual and personalized messages.
Use "Send Now" as "Deliver Mode" at your own risk!
It is strongly recommended to use "Send Later" as "Deliver Mode" and to check the individual and personalized messages in the folder "Local Folders -> Outbox". Bugs in Thunderbird, bugs in Mail Merge and bugs in other add-ons may lead to unexpected and undesired results.
----------------------------------------------------------------------------------------------------
Attachments: (Global)
Global Attachments, i.e. attachments that are the same for every recipient, can be added normally using the toolbarbutton "Attach".
Attachments: (Individual)
Individual Attachments, i.e. attachments that are different for every recipient, can be added in the "Attachments" field in the Mail Merge Dialog, e.g.:
{{Attachment}}
C:\Path\To\File\{{Attachment}}
Multiple (individual) attachments can be separated by line breaks, e.g.:
C:\Path\To\File\{{Attachment1}}
C:\Path\To\File\{{Attachment2}}
C:\Path\To\File\{{Attachment3}}
----------------------------------------------------------------------------------------------------
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 column names
CSV: (Example)
FirstName,LastName,Gender,Email,Attachment
John,Doe,m,[email protected],C:\MyFile.pdf
Character Set: (Recommendation)
Character Sets Supported by Thunderbird
windows-1252 (Windows)
utf-8 (Linux & Mac)
----------------------------------------------------------------------------------------------------
JSON: (Array of Arrays)
Mail Merge supports UTF-8 encoded files in JSON format with Array of Arrays.
JSON: (Array of Arrays) (Example)
[
["FirstName","LastName","Gender","Email","Attachment"],
["John","Doe","m","[email protected]","C:\\MyFile.pdf"]
]
----------------------------------------------------------------------------------------------------
Spreadsheet:
Support for spreadsheets is based on SheetJS. See: File Formats supported by SheetJS
----------------------------------------------------------------------------------------------------
Batch: (Start, Stop and Pause)
Start: Number of the First Message (optional)
Stop: Number of the Last Message (optional)
Pause: Pause between Messages in Seconds (optional) (variables are supported)
Pause: (Advanced)
The "Pause" field supports fixed and random pauses as well as variables, e.g.:
Fixed Pause: 10 (Pause 10 seconds)
Random Pause: 10-60 (Pause between 10 and 60 seconds)
Variables: {{Pause}}
----------------------------------------------------------------------------------------------------
Send Later:
Mail Merge supports Send Later:
User Guide
----------------------------------------------------------------------------------------------------
Line Breaks:
Thunderbird uses an HTML editor internally. You can create line breaks with <br>.
Links and Images:
Thunderbird uses an HTML editor internally. You can create (individual) links and (individual) images with "Insert -> HTML", e.g.:
Link: <a href="{{link}}">
Image: <img src="{{image}}">
----------------------------------------------------------------------------------------------------
Preview File Dialog:
Screenshot: Preview File Dialog
The "Preview File Dialog" offers you the chance to briefly check the file, i.e. CSV, JSON or Spreadsheet. It is no adequate compensation for inspecting the files themselves!
Preview Message Dialog:
Screenshot: Preview Message Dialog
The "Preview Message Dialog" offers you the chance to briefly check the messages. It is no adequate compensation for inspecting the individual and personalized messages themselves!
----------------------------------------------------------------------------------------------------
Deliver Mode Warning
Screenshot: Deliver Mode Warning
Use "Send Now" as "Deliver Mode" at your own risk!
It is strongly recommended to use "Send Later" as "Deliver Mode" and to check the individual and personalized messages in the folder "Local Folders -> Outbox". Bugs in Thunderbird, bugs in Mail Merge and bugs in other add-ons may lead to unexpected and undesired results.
Recipients Reminder:
Screenshot: Recipients Reminder
The "Recipients Reminder" shall prevent accidentally clicking on "Send Now" or "Send Later". To start Mail Merge please click "Cancel" and use the menu "File -> Mail Merge" or the toolbarbutton "Mail Merge". The "Recipients Reminder" can be activated and deactivated in the Mail Merge Options ("Tools -> Add-ons Preferences -> Mail Merge"). Threshold: extensions.mailmerge.recipients
Variables Reminder:
Screenshot: Variables Reminder
The "Variables Reminder" shall prevent accidentally clicking on "Send Now" or "Send Later". To start Mail Merge please click "Cancel" and use the menu "File -> Mail Merge" or the toolbarbutton "Mail Merge". The "Variables Reminder" can be activated and deactivated in the Mail Merge Options ("Tools -> Add-ons Preferences -> 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
{{PrimaryEmail}}: the variable will be replaced by the value of the field PrimaryEmail
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}} (includes)
If the value of the field name includes if, then the variable will be replaced by then, else by else.
Variable: {{name|^|if|then|else}} (starts with)
If the value of the field name starts with if, then the variable will be replaced by then, else by else.
Variable: {{name|$|if|then|else}} (ends with)
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.
Nested Variables:
Variables can be nested. For example: To create individual emails only for your premium customers, you can add something like this in the To field:
{{FirstName}} {{LastName}} <{{Premium|x|{{Email}}}}>
{{Premium|x|{{Email}}}}
Warning: (Variables in the From / To / Cc / Bcc / Reply fields)
Advanced variables like "includes", "starts with" and "ends with" as well as the "numbers" may not work as expected in the From / To / Cc / Bcc / Reply fields!
----------------------------------------------------------------------------------------------------
Address Book:
Addressbook Properties Supported by Thunderbird
{{FirstName}}
{{LastName}}
{{DisplayName}}
{{NickName}}
{{PrimaryEmail}}
{{SpouseName}}
{{FamilyName}}
{{SecondEmail}}
{{HomeAddress}}
{{HomeAddress2}}
{{HomeCity}}
{{HomeState}}
{{HomeZipCode}}
{{HomeCountry}}
{{WebPage2}}
{{WorkAddress}}
{{WorkAddress2}}
{{WorkCity}}
{{WorkState}}
{{WorkZipCode}}
{{WorkCountry}}
{{WebPage1}}
{{HomePhone}}
{{WorkPhone}}
{{FaxNumber}}
{{PagerNumber}}
{{CellularNumber}}
{{JobTitle}}
{{Department}}
{{Company}}
{{Custom1}}
{{Custom2}}
{{Custom3}}
{{Custom4}}
{{Notes}}
{{AnniversaryYear}}
{{AnniversaryMonth}}
{{AnniversaryDay}}
{{BirthYear}}
{{BirthMonth}}
{{BirthDay}}
{{_AimScreenName}}
{{_GoogleTalk}}
{{_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}}
Address Book:
gContactSync
{{ThirdEmail}}
{{FourthEmail}}
{{HomeFaxNumber}}
{{OtherNumber}}
{{PrimaryEmailType}}
{{SecondEmailType}}
{{ThirdEmailType}}
{{FourthEmailType}}
{{WorkPhoneType}}
{{HomePhoneType}}
{{FaxNumberType}}
{{CellularNumberType}}
{{PagerNumberType}}
{{HomeFaxNumberType}}
{{OtherNumberType}}
{{WebPage1Type}}
{{WebPage2Type}}
{{Relation0}}
{{Relation1}}
{{Relation2}}
{{Relation3}}
{{Relation4}}
{{Relation5}}
{{Relation0Type}}
{{Relation1Type}}
{{Relation2Type}}
{{Relation3Type}}
{{Relation4Type}}
{{Relation5Type}}
----------------------------------------------------------------------------------------------------
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
The configured "Types" in the "CardBook Preferences" can be used by its "Code" as a first parameter for the properties address, email, impp, phone and url. For example:
{{adr#home}}
{{adr#work}}
{{email#home}}
{{email#work}}
{{impp#home}}
{{impp#work}}
{{tel#cell}}
{{tel#fax}}
{{tel#home}}
{{tel#work}}
{{url#home}}
{{url#work}}
In case you have multiple entries, you can use a number as a second parameter for the properties address, email, impp, phone and url. For example:
{{url#home#0}}
{{url#home#1}}
{{url#home#2}}
CardBook: (Custom Fields)
CardBook
The configured "Custom Fields" in the "CardBook Preferences" can be used by its "Field Name". For example:
{{others#X-CUSTOM1}}
{{others#X-CUSTOM2}}
{{others#X-CUSTOM3}}
{{others#X-CUSTOM4}}
----------------------------------------------------------------------------------------------------
Custom Headers:
Mail Merge supports Custom Headers:
mail.compose.other.header
----------------------------------------------------------------------------------------------------
Debug:
View Log Messages in the Error Console ("Tools -> Developer Tools -> Error Console")
----------------------------------------------------------------------------------------------------
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]
----------------------------------------------------------------------------------------------------
Copyright:
Logo and icons are based on FontAwesome.
Support for spreadsheets is based on SheetJS.
----------------------------------------------------------------------------------------------------
Donation:
Please support the development of Mail Merge with a donation (PayPal):
5 Euro | 10 Euro | 15 Euro | 20 Euro | 25 Euro
5 Dollar | 10 Dollar | 15 Dollar | 20 Dollar | 25 Dollar