To try the thousands of add-ons available here, download Mozilla Firefox, a fast, free way to surf the Web!
CloseWelcome to Firefox Add-ons.
Choose from thousands of extra features and styles to make Firefox your own.
CloseReviews for Mail Merge
226 reviews for this add-on
Rated 5 out of 5 stars
Extremely clever and useful extension, and excellent support from the developer. At the moment (Thunderbird 38.0.1) messages must be composed in html format to keep line breaks, but the issue is being looked at.
This review is for a previous version of the add-on (3.10.1).Rated 5 out of 5 stars
1a
This review is for a previous version of the add-on (3.9.1).Rated 4 out of 5 stars
Tip: If you use Excel, save your CSV as an "MS-DOS Comma Separated (.csv)." Any other of the CSV choice in Excel will fail.
Request: Add a "cancel" feature to the mailmerge process. On those occasions when the CSV file is incorrect, MailMerge hangs, cannot be stopped or closed, and Thunderbird must be force-quit. Quite a pain in the petard. Have a "Cancel" feature that can be invoked during a failing merge would be huge.
Rated 5 out of 5 stars
Thank you Hottie-Doll, for your helpful and detailed review. IT helped me get past the CSV file merge problem that had me stopped for a day.
All I had to do was remove the spaces around the commas (between the fields), and the magic started. Works great.
Thank you to the developer, and pls ignore my long email for help. I will be donating.
Not to ask for the moon now, BUT if we can schedule emails, that would be something. For example, I want to send 5 follow-ups one week apart to my list.
Still, this is one great add-on. Thanks again.
Rated 5 out of 5 stars
- INTRO -
Many people here are having trouble/difficulty with their initial configuration. As warbieguy put it "Once I nutted out what to do, it was very easy. But the instructions are too terse." So rather than doing a quick start for newbies (I may still do one later) like I did for Stationery add-on, which by the way works very nicely with this add-on. I felt it would be more helpful to review what problems people reporting (going by the reviews posted here) and cover them all in one review so people will not need to dig through 120+ reviews to find something. The developer has been reported to be very helpful, so if this does not help you can give him an email. OK I think I am done with the "plugs". :)
----------------------------------
- TEST BEFORE EMAIL -
The newest review (as of this writing) was by JBourne123 "Normal address book works great . . . BUT crashing Thunderbird for CSV files" I have not seen this and I use the .csv files all the time. If your having problems like this or any other problem you can not "nutout" email Alexander Bergmann the link is on the right side look under "Support E-mail". However before you do that I would suggest that you download a clean new Thunderbird (you can use the portable Thunderbird so as not to add/change a your profile) and try it out with no add-ons or themes.
----------------------------------
- PICTURES -
Some people have had problems embedding pictures and images in mail body/signature. Keep in mind that you much be using HTML in your emails to embed pictures/images. Another add-on called "Always HTML" may help https://addons.mozilla.org/en-US/thunderbird/addon/always-html/ One person stated "tried author's suggested workaround for embedding images, but it doesn't work 100%. sometimes my signature image shows up but left out another image, vice versa, or both would get left out. though if i keep my mailing group real small (<5) it seems to work fine". This may be, in part, do to the size of your images. Hard to say.
----------------------------------
- ADDRESS BOOK VS. .CSV -
Quokka Systems said "I used the link to a CSV file which allowed huge flexibility." What I think he is talking about is the fact that you can use Thunderbirds address book OR a .csv file to make your bulk mail. When you use the address book you have to use very exact terms for the values/properties/variables your using to make your mass mailing(s). Look above at the add-on description for more information on the term/properties you can use with the address book, he has a link with even more. ALSO note when using the Address book (unlike using a .csv file) the "Recipients To:" section works differently. When using the address book you just add all the people into the "Recipients To:" plane and then the Mail Merge add-on will "split them up" into separate emails. NOW when using a .CSV file Variables are supported differently. In the example just stated with the "Recipients To:" you can have Variables when using .vsc files. So even though I have not tried it, this means (I think) that one could have many people set-up in the "Recipients To:" section. It would be a pain in the butt to set up (you would need to have the .csv file set up just right) and I see no reason to do that since both the CC and BCC work with Variables and the fact you can send everyone their own personal email but the point is you could do it if you wanted to. You see when using a .csv file to do your mailing list you can use as many fields from a .csv file as you want, aka make up your own fields. To be clear, you could make a field that says TheirDogsName in the header of the .csv file and then when you put {{TheirDogsName}} in your email, this add-on will find the header that says TheirDogsName, then find the person that it matches (via the email address) and put their dogs name in the spot you said to. As long as you follow the rules this can do a lot, and do not even get me started with you can do with the if/then options. LOL
----------------------------------
- HOW BIG CAN .CSV BE -
Many people have asked what is "the limit of addresses per csv file, if any" and from what I have read it seems to be different for different people. One person reported "I tried a .csv list with 407 names and I had to break it into 4 separate files to get it to work. Other than that, it works great; the documentation could be a bit better, that's all." yet keep in mind "If using this add-on, it may be best to mail only 50 or so people at a time and have an hour's break between batches so that your ISP does not ban you for spamming." Yet some people say they have to keep it very small for it to work, where others report sending out "1000 email within a CSV file and it works great." I believe the amount you can send at one time changes, depending on what kind situations you have.
----------------------------------
- ENIGMAIL -
Enigmail creates trouble, from day one. It is not supported at this time. I have other add-ons that do not use Enigmail plus some of the POP severs I use do not support it so I do not use it. Others have reported: If Enigmail is installed, it will encrypt every outgoing email with YOUR key only. This makes the message unreadable for the intended recipients. Disable Enigmail with a restart of Thunderbird, run your mail merge, then your can re-enable Enigmail.
----------------------------------
- OUTBOX PROBLEM -
On person said "Mass Mail should send the separated e-mails for each recipient automatically from the outbox. Currently the user needs to send the mails manually." I use the "Mail Merge" add-on with another add-on called "Send Later" add-on so I have not seen this action and do not know if it still applies, just a heads up that you may run into it.
----------------------------------
- MUST BE GODLIKE WITH ENTERIES -
People have requested that "unsent mails due to erratic email address will be skipped and continue sending out the next unsent message, rather than pausing the whole queue of outgoing unsent messages", yes it is a pain in the butt. Yet if it was to do "skip" bad entries you would then need also change the add-on so you could be notified of what ones was skipped and why they where skipped. Otherwise you would have no idea who got what emails your list(s). I do not know a lot about programming but I do know enough about it to know that it would take a lot of work to add that. YES it would be VERY nice to have that function. Where it is good to make suggestions, as part of giving feedback, please to not "write a bad review" that the program is bad or broken because of this. On that note, Dave S said "I gave this a try and had trouble. If there is a bad email in the list it stops in the middle of your list and it is difficult to determine where. So unless you are sure your list is clean this is not the best product to use." Yes I ran into that situation as well. The "trick" I used to find the "bad egg" in the bunch was to make a copy of the .csv file and delete 1/2 of the items and see if it worked, thereby cutting the amount of entries I had to search in 1/2. Then again if needed. If your using the address book to make your mailing, the "trick" will not work as well. One more reason to use .csv files over using the address book if you have big lists.
----------------------------------
- CHARACTERS & SPACES -
CSV files are case/blank space sensitivity, this is very important when using Mail Merge with a .csv file. Kinda 2 or 4 points to make at one time here, they kinda go together. It has been said in reviews time and again that .csv file no not allow for certain characters like apostrophes, slashes, space characters and such. ALSO Keith Tyler said "This made so simple what I was trying to do with a complex awk-and-shell script! Just organize the data into a CSV, insert headers, and create your email. The only thing I wish I could figure out is how to embed line breaks in CSV or have TB or MM convert something else to line breaks. But I just split the values into separate fields and added them one by one and it did the job."
Now I am not sure what exactly what values Keith had to split, have not talked to Keith so I do not know what he was trying to do here but it does bring to mind some things I would like to share. Symbols outside of the character set that your using will mess things up. Now .CVS files can support text (items) in quotes. Remember that with .CVS files you can have a blank field if you just have a space surrounded by quotes like this " " ALSO you MAY be able to use special characters in the quote marks. Let me back up a bit here first thing you need to make sure is that your using the same Character Set with this add-on (it gives you the chance to check what one your using in the option window that opens after you start the merge) as the one your .cvs file is using. Here is the Character Set to use: Windows-1252 (Windows), UTF-8 (Linux) and UTF-8 (Mac) however I have use UTF-8 on my PC and seems to work fine with CSV files. So you MAY be able to use a "non-supported" Character Set for your set up to get the characters your looking for. Careful this will void the warranty you got from your "Mail Merge" add-on. :)
JeanneR said in part "This is really lovely . . . you might think that a space follows a comma. Not so. Kill any spaces around commas and all will sail smoothly . . . Well worth making a contribution so that Alexander is adequately rewarded and keeps up the good work."
Yes this is a .CSV thing nothing to do with this program. I know a little bit about .CVS files and I still made a boo boo with the way the entries are separated. My problem was that the .CVS file was set to use BOTH tabs and commas and I did not notice that the .cvs file was USING THE TABs to separate the values. I had the add-on set to use "just" commas. I knew this and it still slipped by me; took a 1/2 a day to "fix" it. Yea, I know, I am not the quickest duck in the water sometimes.
----------------------------------
- CLEAN MY TBIRD -
I found many people talking about removing dead/old emails and/or for sorting emails and people even talking about bounced emails. Seems beyond the scope of this add-on to me. People have made all encompassing add-ons to Thunderbird before, "mail tweaks" come to mind here. The problem with them is 2 fold. Most people do not want/need all the functions and it is to complex or bloated for them and 2nd is that since Thundebird is always upgrading big multi use add-ons become to much to keep up on. I did make an add-on collection called FOLDER & FILTERS plan to make one for "flushing/trash/delete" but have not had the time to review them all well enough to suggest any of them but ThunderPlunger comes to mind and there are some add-ons to auto compact and repair folders but like I said, I have not reviewed them all yet so I can not suggest the best ones. PEASE do not get me wrong here, I do not mean to suggest that people should not make suggestions. What I am saying is there may be other add-ons that do what you want and maybe even better than you hoped for.
----------------------------------
SOME QUICK NOTES:
At times good to remember the 'Edit message as new' action to start new (or another) Mail Merge section.
Don't leave any spaces between field separators in your csv file .
Does work with embedded images if you embed them with an internet link.
Sometimes you need to re-try mail merge like when editing a CVS folder when an "write" window/tab is open.
I use Lebra Office but some people may find this helpful: "The .csv file failed when created from an Excel (2003) spreadsheet (file/save as). I opened the .xls file in Open Office and saved it as a .csv file and it worked fine."
I use Linux and Windows but MAC people may find this helpful: "If you use Apple address book, looks like you will have to convert to a .CSV file before you use this addon. Thing is after you convert your Apple address book into a .CSV file you can then upload it into Thunderbird's address book."
Dan Kelly said "AMAZING PLUGIN! AMAZING SUPPORT! It's free, but certainly worth donating if you use it. I've seen $100 mail merge software programs that don't work this well." I agree.
THANKS Alexander for all your work on this add-on.
Rated 5 out of 5 stars
Worked perfectly as described and generated 500+ drafts. It's really exciting to see hundreds of drafts being generated in minutes! I also feel safe because it gives me a chance to add or customize personal message before I send (if you choose "Save As Draft").
This review is for a previous version of the add-on (3.9.1).Rated 3 out of 5 stars
Pretty nice addon. Import from CSV can do the job but it lacks DIRECT support of commonly used programs (i.e. MSAccess or MSExcel) as external sources. It would be nice to have such a feature.
This review is for a previous version of the add-on (3.9.1).Rated 4 out of 5 stars
As others already said, this is a great add-on that can save you a lot of time. However, you have to disable Engimail first, otherwise each email is sent encrypted. Please fix this to get the fifth star. :-)
This review is for a previous version of the add-on (3.9.0).Rated 4 out of 5 stars
Like Jeffrey below, I had the unpleasant experience of sending out a bunch of encrypted messages because of interference with Enigmail. Please fix this!
Other than that, this is a great add-on.
Rated 4 out of 5 stars
I have to say, this is a very nice addon. However, if Enigmail is installed, it will encrypt every outgoing email with your key only. This makes the message unreadable for the intended recipients. Disable Enigmail with a restart of Thunderbird....run your mail merge, then re-enable Enigmail........
This review is for a previous version of the add-on (3.9.0).Rated 5 out of 5 stars
Great and nifty addon.
This review is for a previous version of the add-on (3.8.0).Rated 5 out of 5 stars
Very usefull add-on.
Quick and easy to use.
Rated 5 out of 5 stars
For mailing lists of 50-250 addresses, this works perfectly and a great solution over using a 3rd party service or trying to setup PHPList or some other server-side mailer.
It's an easy multi-step process. Install the Add-on. Compose the message adding per-recipient customizations. An easy one is to just change a generic "Hi," to "Hi {{FirstName}},"
Save the message as a Draft, but before closing it, choose File -> Mail Merge. It'll go through and create an unsent message for each recipient listed, looking up the replacement values in the address book (default) and doing the swap. So since the messages are now created and residing in the Outgoing folder, can inspect them for a final sanity check before sending.
To send the messages, click File -> Send Unsent Messages. It will churn through them sending each one individually, which creates a copy of the message in the Sent folder.
It's just that simple, really. Seriously, if you only have a dozen to 50-or-so people to send to, use this vs trying to setup something on a server or using a 3rd-party service.
FYI, it takes a while to send individual messages using this process, but it also takes a while using other solutions. The difference is you do not have to baby sit through the compiling/sending but it's not instantaneous either way.
Rated 4 out of 5 stars
This add-on doesn't look so fancy: You need to read the instruction to get to know how this works.
I just needed to simple bulk sending so I didn't have much problems. It wasn't really practical when I had to learn a lot to get what's really handy, but it already did the job so I guess this is great!
Rated 5 out of 5 stars
Used it using the CSV method and worked seamlessly with Thunderbird 24.6
This review is for a previous version of the add-on (3.8.0).Rated 5 out of 5 stars
Great add-on. I knew what the add-on was supposed to accomplish, and it took me less than 5 minutes to start using it. I use the CSV file option and it's easy to use and does what I need. This add-on is a must-have for me.
This review is for a previous version of the add-on (3.7.1).Rated 5 out of 5 stars
I have run the mail merge with 50 to 1000 email within a CSV file and it works great. I have created templates using HTML and created emails with these templates and everything works great. We have a winner.
This review is for a previous version of the add-on (3.7.1).Rated 3 out of 5 stars
I gave this a try and had trouble. If there is a bad email in the list it stops in the middle of your list and it is difficult to determine where. So unless you are sure your list is clean this is not the best product to use.
This review is for a previous version of the add-on (3.7.1).Rated 5 out of 5 stars
Возникла проблема с использованием таблиц csv. Оказалось, что несмотря на то, что при сохранении Excel пишет CSV (разделители - запятые) (*.csv). В действительности разделители - точка с запятой ( ; ).
Как лечится ))): В MailMerge в поле "Field Delimiter" указываем ( ; )
И будет Вам счастье )
Rated 5 out of 5 stars
Easy installation; worked straightaway as expected. Very flexible.
This review is for a previous version of the add-on (3.7.1).To create your own collections, you must have a Mozilla Add-ons account.