How To Mail Merge In Thunderbird?

Mail merge is the process of taking data from any database, spreadsheet, or other similar forms of structured data and then inserting the data into certain documents like mailing labels and letters. Usually, two files will be necessary for any mail merge. Now, let us see how to mail merge in Thunderbird:

Step 1-Creation of the Personalized Email CSV File

On your computer, open Microsoft Excel. Then, enter the information given below:

  • Step 1: In Cell A1, enter the first name
  • Step 2: In Cell B1, enter the last name
  • Step 3: In Cell C1, enter your email address
  • Step 4: From row 2, type in the first name, last name, and the email address for the recipients, that is, the information for the people to whom you wish to send your message.
  • Step 5: When you have typed in all the information, please save your file as a CSV file. To do the same, you can make use of the following steps:
  • Step 6: Go to File->Save->As.
  • Step 7: In the Save As field, enter email-list
  • Step 8: In the File Format field, enter Comma Separated Values (.csv)
  • Step 9: Then, click on the Save button.
  • Step 10: Now, a sample CSV file will be attached (for your review).
  • Step 11: You can now come out of Microsoft Excel.

Step 2-Installation of the Thunderbird Mail Merge Extension:

  • Step 1: On your computer, launch Thunderbird. Then, select the Tools Add-ons option.
  • Step 2: Choose the Get Add-ons option.
  • Step 3: Now, search for the Mail Merge option.
  • Step 4: When you have located Mail Merge, please click on the Install button.
  • Step 5: You can now restart Thunderbird.
  • Step 6: Follow these steps on how to mail merge in thunderbird.

Step 3-Creation of Email Merge Message to be sent to all your recipients:

  • Step 1: The first step is to open Thunderbird and then start a new message.
  • Step 2: The second step will be to create your message. Please surround the text that you wish to add from the previously created CSV file using two curly braces: {{text}}
  • Step 3: Please look at the example given here to understand how you have to create your message:
  • Step 4: To: {{email}}
  • Step 5: Subject: The same subject
  • Step 6: Dear {{first name}},
  • Step 7: How are you? I am sending this message to you…
  • Step 8: With regards,
  • Step 9: My Name
  • Step 10: After you have completed writing your message, click the File Mail Merge option.
  • Step 11: Using these steps on how to mail merge in thunderbird.

A dialog window will now pop up. Here, please fill in the sections as per the content given below:

In the MESSAGE section:

  • Step 1: Source: CSV
  • Step 2: Deliver Mode: If you select the Save As Draft option, the merged emails will be saved in your drafts folder.
  • Step 3: In case you choose the Send Later option, the merged mails will be saved in your Outbox.
  • Step 4: When you select the Send Now option, the merged mails will be sent immediately.
  • Step 5: Important Note: Since the Send Now option does not give you the opportunity to review your generated mails, it is usually not recommended.
  • Step 6: Users generally recommend the Send Later option.

In the CSV section:

  • Step 1: File: Please enter the path for the file that you created in Step 1.
  • Step 2: Character Set: UTF-8
  • Step 3: Field Delimiter: ,
  • Step 4: Text Delimiter: “

In the BATCH section:

  • Step 1: Start: Please enter the first row of your CSV file.
  • Step 2: Stop: Please enter the last row of your CSV file.
  • Step 3: Pause: In case you have set the Deliver Mode to Send Now, please set a value between 2 and 5. This value indicates the amount of time Thunderbird waits between sending your email messages.
  • Step 4: Now, click on the OK button.
  • Step 5: When you have clicked on the OK button, your mail merge will run.
  • Step 6: If you have set your Deliver Mode to Send Now, your messages will be sent automatically. In case you have set the Deliver Mode to Send Later, your merged mails will get saved in Outbox under Local Folders.
  • Step 7: You can check one or two of your mails to confirm that your merge has worked correctly.
  • Step 8: Once you are satisfied that your merge functions properly, you can send your mails by choosing File->Send->Unsent Messages.
  • Step 9: You have now successfully finished your mail merge in Thunderbird.
  • Step 10: We have now seen the steps on how to mail merge in Thunderbird by using the data from Microsoft Excel.