Plugin Name - Mail merge 

  1. Install the Thunderbird mail merge extension:
    1. Download the Thunderbird Mail Merge extension
    2. Open Thunderbird and navigate to Tools > Add-ons
    3. Click on the Gear icon drop down and choose Install Add-on from File and select the .xpi file you downloaded
    4. Restart Thunderbird to finish the installation

Perform a mail merge:

  1. Create a spreadsheet with the data you want to merge into an email. Row 1 should contain a header name for each column
  2. Save the spreadsheet as a .CSV file
  3. Once you download the add-on, click on Write and start creating your message.

click write

 

  1. Create your template by adding the Variable(s)
  2. 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:

  1. {{Email}}
  2. {{FirstName}}
  3. {{LastName}}
  1. In our example, we add a variable in the To, Subject, and body of the email.add variables

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.

locating mail merge

 8. Click on Mail Merge and a dialog box will pop up. Here is a description of the various options:https://web.ideolve.com/ideolve.ws/user/rahul.oli@mithi.com/note/18d3abfd-d099-4899-b39c-5579eccc223a/file/63fa855c-0468-4d7c-a4f6-1c69076b15a6?cmd=download 

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.