Plugin Name - Mail merge
- Install the Thunderbird mail merge extension:
- Download the Thunderbird Mail Merge extension
- Open Thunderbird and navigate to Tools > Add-ons
- Click on the Gear icon drop down and choose Install Add-on from File and select the .xpi file you downloaded
- Restart Thunderbird to finish the installation
Perform a mail merge:
- Create a spreadsheet with the data you want to merge into an email. Row 1 should contain a header name for each column
- Save the spreadsheet as a .CSV file
- Once you download the add-on, click on Write and start creating your message.
- Create your template by adding the Variable(s)
- You can create your template by adding these things:
– The To
– The Subject
– The Body
There are different ways you can format the variable options. Here are the different ways you can do it:
- {{Email}}
- {{FirstName}}
- {{LastName}}
- In our example, we add a variable in the To, Subject, and body of the email.
7. Click File = > Mail Merge
Once you created your email template, click on Files and then click on Mail Merge. You can also find it in the top right corner when you create your email template.
8. Click on Mail Merge and a dialog box will pop up. Here is a description of the various options:
9. File: click Browse and select the csv file you created earlier
10. Character Set: the default should be fine
11. Field Delimiter: leave the "," if you are using a comma separated file (like this example)
12. Under Batch you can choose to send only a certain number of the email
13. Click SAVE, and the mail merge will run
14. If you selected Send Now for Deliver Mode, skip the rest of this step since your emails have already been 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
NOTE: It will take 3 Sec per mail to read CSV header and send.