Mail merge thunderbird инструкция

Описание Mail Merge

Дополнение Mail Merge (объединение писем) для почтового клиента Thunderbird (буревестник) предназначено для массовой рассылки почты, когда необходимо, чтобы адресат видел только свой адрес в поле «Кому».

Ключевые возможности:

• Рассылка неограниченному числу адресатов.
• Адресаты не видят кому ещё было отправлено это же письмо.
• Персонализация письма за счёт переменных. Составляется шаблонное письмо, где вместо Имени, Обращения, Дня Рождения и т.д. ставятся переменные, соответсвующие полям в адресной книге.
• Поддержка проверки условий на переменные (if|then|else)
• Поддержка регулярных выражений (regexp)

Установка Mail Merge

1. Скачиваем Mail Merge c официальной страницы дополнения: https://addons.mozilla.org/ru/thunderbird/addon/mail-merge/
2. Устанавливаем в Thunderbird как любое дополнение:
   1. меню Инструменты
   2. подменю Дополнения
   3. кнопка Инструменты для всех дополнений (рядом со строкой поиска, вверху справа)
   4. пункт Установить дополнение из файла. Выбираем скаченный файл.
3. Перезагружаем Thunderbird

Создание рассылки

1. Создаём обычное письмо: Файл — Создать — Сообщение (или просто Ctrl + N)
2. Отправляем с помощью Mail Merge: Файл — Mail Merge — OK
   • Перед нажатием на ОК можно поменять режим отсылки Deliver Mode:
     • Save As Draft — сохранить в черновиках. Создаёт отдельные письма для всех адресатов и помещает их в папку Черновики (не посылая).
     • Send Later — отправить позже. На самом деле что происходит с письмами не ясно, но они не отправляются и нигде не сохраняются.
     • Send Now — отправить немедленно.

Пример письма с переменными

Указанные ниже переменные (слова в фигурных скобках {{Переменная}}) берутся из адресной книги.

Кому: Клиенты <«Список клиентов»>

Тема: Подтверждение данных

Здравствуйте, {{FirstName}}!

Прошу подтвердить Ваши данные: 
* День рождения: {{BirthDay}}.{{BirthMonth}}.{{BirthYear}}
* Рабочий телефон: {{WorkPhone}}

Всего доброго, 
Служба тех. поддержки

Полезные советы

• Если список адресатов постоянен, то удобно создать в адресной книге список рассылки и добавлять лишь его вместо перечисления всех адресатов.
• Создайте тестовый список рассылки с несколькими своими почтовыми ящиками и проверяйте на нём каждую новую рассылку, прежде чем посылать её людям.

См. также

• Официальную страницу(на англ.) для более полной и актуальной информации по Mail Merge.

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.

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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

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

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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)

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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.

Картинка с сайта: yoyofumedia.com

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!

>>>>>> INSTRUCTIONS FOR PERFORMING A THUNDERBIRD MAIL MERGE <<<<<
I. Create Personalized Email CSV File:

1. Launch Microsoft Excel.
2. Enter the following information:

Cell A1 — firstname
Cell B1 — lastname
Cell C1 — email

3. Enter the first name, last name and email address for the people
that you intend to send your message to beginning in row 2.
4. After entering the information, save the file as a CSV file.

File > Save > As >

Save As: email-list
File Format: Comma Separated Values (.csv)
Click on the Save button.

A sample CSV file is attached for your review.

5. Close Microsoft Excel.

II. Install Thunderbird Mail Merge Extension:

1. Launch Thunderbird.
2. Click on Tools Add-ons
3. Click on Get Add-ons.
4. Search for «Mail Merge».
5. Click on the «Install» button to install it.
6. Restart Thunderbird.

III. Prepare an Email Merge Message to send to all intended recipients

1. Open Thunderbird and start a new message.
2. Write your message. Surround any text that you want to include from
the csv file you previously with two curly braces: {{text}}. For example:

>>>>>> SAMPLE BELOW <<<<<
To: {{email}}

Subject: Same Subject

Dear {{firstname}},

I am writing to you today for …….

Cheers,

My Name

>>>>>> SAMPLE ABOVE <<<<<
3. Once you are happy with your message, click on File Mail Merge.
4. A dialog window will appear. Please set to the following:

MESSAGE Section:

Source: CSV
Deliver Mode: «Save As Draft» will save the merged emails in your
drafts folder. «Send Later» will save the merged emails in your Outbox.
«Send Now» will send the merged emails immediately (note: this will not
give you an opportunity to review the generated emails and is not
recommended). I recommend the «Send Later» option.

CSV Section:

File: enter the path for the file you created in the «Create
Personalized Email CSV File» section of these instructions.
Character Set: UTF-8
Field Delimiter: ,
Text Delimiter: «

BATCH Section:

Start: Enter the first row of the CSV file that contains data.
Stop: Enter the last row of the CSV file that contains data.
Pause: If you sent the «Deliver Mode» to «Send Now», I recommend
setting a value between 2 — 5, which represents that amount of time the
Thunderbird will wait between sending each email message.

5. The mail merge will run after you click on the «OK» button.
6. If you selected «Send Now» for Deliver Mode, the messages will
automatically be 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.