Frequently Asked Question

How do I Mail Merge?
Last Updated 3 years ago

Thunderbird Mail Merge

Since putting everyone in the CC or TO will get you digitally scrutinized in the form of a game of hangman it is best to use a Mail Merge instead.

Note: you CANNOT Mail Merge from the webmail, only using Thunderbird on a PC (in the board room).

Step 1: Install the Add-on

image

Textual: Open Thunderbird, click the hamburger menu on the top right, click on "Add-ons and Themes". In "Find more add-ons" search for "Mail Merge". Click "Add to Thunderbird" and accept the popups.

Step 2: Write your e-mail with variables

image

Using Mail Merge you can mass create personal emails with variables. This means you can personally address people without actually being personal. Variables are defined using:

{{Variable name}}

The main use is using variables for the "To" of your e-mail.

Step 3: Create the Excel Sheet

Mail Merge works by merging an e-mail with an excel sheet. 

image

The column headers should be the same name as the variables is in your e-mail. Mail Merge will take your template e-mail and create a new one using all the variables on a single row.
Make sure to save the sheet as an Excel Workbook

Step 4: Insert the Sheet into the e-mail

image

This is where the magic happens. You select the just created Excel Sheet and can then preview how the e-mail will look like. You can also select if you want to send it now, later, or save as draft. Use send later so you can check if you made any mistakes

Step 5: Check your outbox

image

If you selected "send later" you can now check how the e-mails will be received. As you can see, my 3 rows in Excel turned into 3 personal e-mails I can now send. If you are happy with your fresh e-mails you can send them by right clicking "Outbox" and click "Send Unsent Messages"

That's it. Now you can go and Mail Merge to your hearts content.

Please Wait!

Please wait... it will take a second!