See the Mail Merge extension documentation for full list of supported if-then-else statements and other features.There are various ways to do an Email Mail Merge. Surround any field name that you want to include from mailing list in curly brackets:, If the value of the field firstname equals Marlin, then the value will be replaced by Orlando.

Open Thunderbird and create a new message. Composing Email and Personalizing Message When sending email from CSV file you can include custom field names, when sending from address book you must follow predefined field names, see Mail Merge extension documentation for the list of field name supported by Address Book. File > Save As or Download As > choose CSV comma delimited. Save the spreadsheet as CSV (Comma delimited) file. The first row should contain a name for each column. Creating CSV mailing list using spreadsheet (google sheets, excel etc.)Ĭreate a spreadsheet using google sheets or excel with the data you want to merge into an email. Thunderbird Mail Merge extension can pull data from the Thunderbird Address Book or from CSV file to perform mail merge. To send personalized email you need to have a mailing list, your mailing list contains the recipient’s data to be sent. Restart Thunderbird to finish the installation. Search for Mail merge extension and click “Add to Thunderbird” button. Open Mozilla Thunderbird and navigate to Tools > Add-ons > Get Add-ons. Click on the setting icon, choose “Install Add-on from File…”, and select the. xpi file, open Thunderbird and navigate to Tools > Add-ons > Extensions. After installing Mozilla Thunderbird and setting up your email account, you can add the Thunderbird Mail Merge extension using any of the following methods.ĭownload the Thunderbird Mail Merge extension. Thunderbird can be used to send personalized mass email using Mail Merge extension. Mozilla Thunderbird is a free and open-source email client, available for Linux, MacOS, and Windows platforms. This article shows you how to send personalized mass email using Mozilla Thunderbird mail merge add-on. Mail merge unlike regular email makes each recipient of the message the sole recipient. If you want to send an email to many recipients with same text and graphics, only specific sections of email are personalized, use mail merge.

Mozilla thunderbird mail merge