Download Now

Featured
Add-on Information for Mail Merge
Updated
Website https://addons.mozilla.org/addon/mail-merge/
Works with Thunderbird 3.0 - 3.2a1pre
Rating

Rated 4 out of 5 stars 58 reviews

Downloads 47,162
Add to collection

More about this add-on

Description:
If you send a mail to multiple recipients, there are two common problems: First you don't want each recipient to see the others. The only workaround would be to send a mail (To) to yourself and a Blind Carbon Copy (Bcc) to each recipient or to send more than one mail. Second you are often not allowed to send to more than 25 or 100 recipients at one time. The only workaround would be to send more than one mail.

Mass Mail:
With "Mass Mail" you can create one mail for each recipient from a draft! Write a New Message; add all recipients to To; add Subject, Body and Attachments; click "File -> Mail Merge". For each recipient a new mail is created automatically and stored in "Local Folders -> Outbox". Ready to send: "File -> Send Unsent Messages"

Personal Mail:
With "Personal Mail" you can create one mail for each record in a CSV from a draft! Write a New Message; add the Variable to To; add Subject, Body and Attachments; click "File -> Mail Merge". For each recipient a new mail is created automatically and stored in "Local Folders -> Outbox". Ready to send: "File -> Send Unsent Messages"

CSV: (Personal Mail)

records are separated by line breaks (\r, \n, \r\n)
fields are separated by field delimiters (comma, semicolon, colon)
fields may be enclosed within text delimiters (double quote, single quote)
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


Character Set: (Personal Mail)

Windows: Windows-1252
Linux: UTF-8
Mac: UTF-8


Addressbook: (Mass Mail)

{{FirstName}}
{{LastName}}
{{DisplayName}}
{{NickName}}
{{PrimaryEmail}}
{{HomePhone}}
{{WorkPhone}}
{{FaxNumber}}
{{PagerNumber}}
{{CellularNumber}}
{{BirthDay}}
{{BirthMonth}}
{{BirthYear}}
{{HomeAddress}}
{{HomeCity}}
{{HomeState}}
{{HomeZipCode}}
{{HomeCountry}}
{{WorkAddress}}
{{WorkCity}}
{{WorkState}}
{{WorkZipCode}}
{{WorkCountry}}
{{Custom1}}
{{Custom2}}
{{Custom3}}
{{Custom4}}
{{Notes}}


Example: (CSV)

FirstName,LastName,Sex,Mail,Attachment
John,Doe,m,john.doe@example.com,c:\file.pdf


Example 1: (Draft)

To: {{Mail}}
Body: Hallo {{FirstName}} {{LastName}}


Example 1: (Mail)

To: john.doe@example.com
Body: Hallo John Doe


Example 2: (Draft)

To: {{FirstName}} {{LastName}} <{{Mail}}>
Body: Hallo {{FirstName}} {{LastName}}


Example 2: (Mail)

To: John Doe <john.doe@example.com>
Body: Hallo John Doe


Example 3: (Draft)

To: {{FirstName}} {{LastName}} <{{Mail}}>
Body: Hallo {{Sex|m|Mr.}}{{Sex|f|Mrs.}} {{LastName}}


Example 3: (Mail)

To: John Doe <john.doe@example.com>
Body: Hallo Mr. Doe


Example 4: (Draft)

To: {{FirstName}} {{LastName}} <{{Mail}}>
Body: Hallo {{Sex|m|Mr.|Mrs.}} {{LastName}}


Example 4: (Mail)

To: John Doe <john.doe@example.com>
Body: Hallo Mr. Doe


Example 5 (Draft)

Attachments: file://{{Attachment}}


Error Message: (Check the Filename)

[Exception... "Component returned failure code: 0x80520012 (NS_ERROR_FILE_NOT_FOUND) [nsIFileInputStream.init]" nsresult: "0x80520012 (NS_ERROR_FILE_NOT_FOUND)" location: "JS frame :: chrome://mailmerge/content/overlay.js :: anonymous :: line XYZ" data: no]


Error Message: (Check the Character Set)

[Exception... "Component returned failure code: 0x80500001 [nsIConverterInputStream.init]" nsresult: "0x80500001 (<unknown>)" location: "JS frame :: chrome://mailmerge/content/overlay.js :: anonymous :: line XYZ" data: no]


Error Message: (Check the Character Set)

[Exception... "Component returned failure code: 0x8000ffff (NS_ERROR_UNEXPECTED) [nsIConverterInputStream.readString]" nsresult: "0x8000ffff (NS_ERROR_UNEXPECTED)" location: "JS frame :: chrome://mailmerge/content/overlay.js :: anonymous :: line XYZ" data: no]


Links:
Character Set
Comma-separated values
Delimiter-separated values
Addressbook Properties Supported by Thunderbird
Character Sets Supported by Thunderbird

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

Bugs:
Mail Merge does not support embedded images
Mail Merge does not support mailing lists

Workaround: (Embedded Image)
Upload the Image to a Webserver, click "Insert -> Image" and enter the URL

Workaround: (Mailing List)
Open the Addressbook, select the Mailing List and click "File -> New -> Message"

Image Gallery

Developer Comments

If you need help, feel free to contact me by mail (English and German)!
Donation (PayPal): 5 Euro | 10 Euro | 15 Euro

Reviews

Mail Merge

Great app....thanks so much for supporting TB.

Rated 5 out of 5 stars by Jack Reisbeck on May 18, 2011

I added Mail Merge to my Thunderbird a few days ago. Now after sending out a newsletter for nearly 3 years with a bland cover mail, I am able to personalize the email. That is so great! I have found Alexander's support speedy and comprehensive.

If you need to send out personalized emails to a club, social group, or anyone, this add-on will do what you need. I recommend it highly.

Thank you,
Jef.

Rated 5 out of 5 stars by Jef on May 15, 2011

Ein klasse Tool! Das Individualisieren der Massenmails ist wirklich gut gelöst und einfach handzuhaben!

Rated 5 out of 5 stars by Zuckerfuchs on April 20, 2011

See all 58 reviews of this add-on

Release Notes

Version 2.2.0 April 23, 2011 6.1 KB

Download Now

Featured
Works with:
  • Thunderbird 3.0 - 3.2a1pre
New: Support for Attachments
Source Code License What's this?