YoYoFuMedia Online Marketing Company Icon

How To Use Mail Merge Thunderbird Add On For Cold Emailing

Share on facebook
Share on twitter
Share on email

Wondering how to create and send hundreds of personalized emails fast every day and not get sent to spam?

We have a solution using the Mail Merge add-on with Mozilla Thunderbird. It can help effectively make your cold email campaign quicker and more effective.

Here are the 10 steps on how to use Mail merge Thunderbird add on:

 

Step 1:  Create a Spreadsheet or Excel Sheet (CSV file)

In our case, we created a Google Spreadsheet then downloaded it as a CSV file. You can use either Excel or Google Spreadsheet as long as Thunderbird can access your file.

How To Use Mail Merge Thunderbird Add On

 

Step 2: Create the columns based on the parameters needed to be used (e.g. name, email, attachment, etc.)

For our example, we kept it simple and only had Name and Email as our parameters.

You can add more columns depending on what you want to add specifically for each of your recipients. For example, if you were to send them a specific image for each, you can add an Image column.

add columns

 

Step 3: Fill in the Rows

Next, you will start filling out your rows with the corresponding information. In this example, we put down two emails and the names of the email recipients.

add name and emails

Afterward, save the sheet.

 

Step 4: Go to Thunderbird and download the Mail Merge Add-On

Then go to Mozilla Thunderbird and download the Mail Merge add-on if you haven’t already.

Thunderbird mail merge add-on

Step 5: Create a New Message (“File -> New -> Message”)

Once you download the add-on, click on Write and start creating your message.

click write

Step 6: Create your template by adding the Variable(s)

You can create your template by adding these things:

– The To 

– The Subject (variables are supported)

– The Body (variables are supported)

– (Global) Attachments (optional)

There are different ways you can format the variable options. Here are the different ways you can do it:

  • {{Email}}
  • {{FirstName}}
  • {{LastName}}
  • <{{Email}}>

In our example, we add a variable in the To, Subject, and body of the email.

add variables

Tip: Make sure your variable in the To: section is entered and highlighted red. If it is not highlighted like the example below, you get an error message.

email is highlighted red

Step 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

 

Step 8: Select Your Source And Check Deliver Mode

In our case, we choose CSV file as our Source and Save As Draft (in case we want to delete a specific email later on)

General section

Step 9: Select the File and check Character Set, Field Delimiter, and Text Delimiter

We then choose the CSV file that we want to use. For the Character Set, Field Delimiter, and Text Delimiter. We left it the same.

CSV section

Step 10: Then Click OK

When you finish filling out the setting, you can click OK

Because we choose Save As Draft as our Deliver Mode, it’s sent to our draft, where you can send them on your own time.

your drafted emails

If you want to send it right away, you change your Deliver Mode to Send Right Away. 

Although this saves time, there are times when you want to change or delete a specific email. That is why we found a way, so you don’t need to individually send an email from your Draft but still have the option to keep your email in Draft if you want to delete an email or double-check later.

 

Bonus Tip #1: Scheduling your email

You have the option to Send Right Away, Send Later, or Sent To Draft.

We pick Sent To Draft because you can implement Send Later as well.

All you have to do is create a column with the Time and Date you want to send the email.

schedule column

Under Send Later, include the parameter {{Schedule}} or the corresponding column name.

schedule your emails

This will create drafts that will send at the times you specified. This is great because you can easily send out 50 emails but spread out through 10 days to prevent your email from being sent to spam.

drafted emails that are scheduled

Steps To Schedule Your Emails:

  1. Create a Schedule column with the time and day you want your emails to be sent
  2. In the mailmerge settings, set your Source, Deliver Mode as Save As Draft, and keep Character Set, Field Delimiter, and Text Delimiter the same.
  3. Scroll down to Send Later
  4. In the At section, put the time and date column. (In our case, we put {{Schedule}} because we named out column Schedule)
  5. Click OK

 

Bonus Tip #2: Using Multiple Email Accounts

Because Thunderbird allows you to manage multiple email accounts, you might want to know a solution to use mailmerge with multiple email addresses.

multiple email accounts

For mailmerge with multiple accounts, let’s say you want to send 15 emails each from your 5 Gmail accounts (Outlook, Yahoo, and other email addresses), then you need 5 different spreadsheets.

You need to create different spreadsheets because each account is tied to a certain spreadsheet.

Steps To Using Mailmerge with Multiple Accounts:

  1. There are different ways to start, but here is what we would do.
  2. Create a Master Sheet with all the emails and their names.
  3. Break the sheet into separate sheets matching the number of email account you want to use
  4. Create your email template
  5. Schedule the time and date that you want your emails to be sent
  6. Use Mail Merge individually on each of your emails
  7. Start your email campaign by pressing OK

 

Conclusion

With these steps, you can make your email campaign easier and more effective. By learning how to use Thunderbird’s Mail Merge add-on, you can create personalized emails that can increase click-through rates without needing to individually write thousands of emails. Also, you can do everything in one with the scheduling feature. Good luck with your cold emailing campaign!

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Want to work with us?

Become one of our successful clients, we've done it before and we'll duplicate the same success for you.

yoyofumedia logo design cropped

YoYoFuMedia is an SEO consulting and digital marketing company. Our specialty is providing top-notch service in search engine optimization (SEO), Conversion Rate Optimization (CRO), and paid online marketing like Google Ads and Facebook Ads. Want to increase your online presence? YoYoFuMedia is your digital marketing company.

Company Info

info@yoyofumedia.com

Social

Digital Marketing Services