How to do a mail merge in Thunderbird?

>>>>>> INSTRUCTIONS FOR PERFORMING A THUNDERBIRD MAIL MERGE <<<<<
I.  Create Personalized Email CSV File:

1.  Launch Microsoft Excel.
2.  Enter the following information:

Cell A1 - firstname
Cell B1 - lastname
Cell C1 - email

3.  Enter the first name, last name and email address for the people
that you intend to send your message to beginning in row 2.
4.  After entering the information, save the file as a CSV file.

File > Save > As >  

Save As:  email-list
File Format:  Comma Separated Values (.csv)
Click on the Save button.

A sample CSV file is attached for your review.

5.  Close Microsoft Excel.

II.  Install Thunderbird Mail Merge Extension:

1.  Launch Thunderbird.
2.  Click on Tools Add-ons
3.  Click on Get Add-ons.
4.  Search for "Mail Merge".
5.  Click on the "Install" button to install it.
6.  Restart Thunderbird.

III.  Prepare an Email Merge Message to send to all intended recipients

1.  Open Thunderbird and start a new message.
2.  Write your message. Surround any text that you want to include from
the csv file you previously with two curly braces: {{text}}. For example:

>>>>>> SAMPLE BELOW <<<<<
To:  {{email}}

Subject: Same Subject

 

Dear {{firstname}},

I am writing to you today for .......

Cheers,

My Name

>>>>>> SAMPLE ABOVE <<<<<
3.  Once you are happy with your message, click on File Mail Merge.
4.  A dialog window will appear.  Please set to the following:

MESSAGE Section:

Source:  CSV
Deliver Mode:  "Save As Draft" will save the merged emails in your
drafts folder. "Send Later" will save the merged emails in your Outbox.
"Send Now" will send the merged emails immediately (note: this will not
give you an opportunity to review the generated emails and is not
recommended).  I recommend the "Send Later" option.

CSV Section:

File:  enter the path for the file you created in the "Create
Personalized Email CSV File" section of these instructions.
Character Set:  UTF-8
Field Delimiter:  ,
Text Delimiter:  "

BATCH Section:

Start:  Enter the first row of the CSV file that contains data.
Stop:  Enter the last row of the CSV file that contains data.
Pause:  If you sent the "Deliver Mode" to "Send Now", I recommend
setting a value between 2 - 5, which represents that amount of time the
Thunderbird will wait between sending each email message.

5.  The mail merge will run after you click on the "OK" button.
6.  If you selected "Send Now" for Deliver Mode, the messages will
automatically be sent.  If you selected "Send Later" for "Deliver Mode",
the merged emails will be stored in "Outbox" under "Local Folders".
Check one or two of the emails to make sure the merge worked properly.
When you are satisfied the merge worked correctly, send the emails by
selecting File Send Unsent Messages.

Keywords: