How to Mail Merge With Gmail

Send personalized emails to your friends, colleagues and customizers with Merge Merge for Gmail and Google Apps.

631 Views 34 Likes
How to Mail Merge With Gmail
11 Steps
Supplies
Embed
1
Go to https://goo.gl/AnQhdK and install the Mail Merge add-on for Google Docs.

Go to goo.gl/AnQhdK and install the Mail Merge add-on for Google Docs.

2
From the Add-ons menu, choose Mail Merge with Scheduler > Create Mail Merge Template.

From the Add-ons menu, choose Mail Merge with Scheduler > Create Mail Merge Template.

Recommended For You
3
After the Mail Merge template is created, go to the Mail Merge menu again and choose Import Google Contacts.

After the Mail Merge template is created, go to the Mail Merge menu again and choose Import Google Contacts.

4
Choose a Google Contacts group from the dropdown to import contacts of that group into your current Mail merge sheet.

Choose a Google Contacts group from the dropdown to import contacts of that group into your current Mail merge sheet.

5
You can attach unique file attachments from Google Drive for each email recipient. Select the File Attachments column of any row and click the Add File Attachments menu.

You can attach unique file attachments from Google Drive for each email recipient. Select the File Attachments column of any row and click the Add File Attachments menu.

6
The File picker opens and you can select one or more files from your Google Drive to attach them to your merged emails.

The File picker opens and you can select one or more files from your Google Drive to attach them to your merged emails.

7
You can send your emails immediately or schedule them for sending later. Put the date and time in the Scheduled Date column and the app will send emails to the corresponding recipient at that time.

You can send your emails immediately or schedule them for sending later. Put the date and time in the Scheduled Date column and the app will send emails to the corresponding recipient at that time.

8
Go to your Gmail and compose a draft. For personalized emails, you an includes fields using the {{column name}} notation and they'll be substituted with the actual column value from the spreadsheet.

Go to your Gmail and compose a draft. For personalized emails, you an includes fields using the {{column name}} notation and they'll be substituted with the actual column value from the spreadsheet.

9
Choose the Run Mail Merge menu to open the wizard. Select the Gmail alias and emails will be sent on behalf of this address. Enter your name while the other fields are optional. Click Continue.

Choose the Run Mail Merge menu to open the wizard. Select the Gmail alias and emails will be sent on behalf of this address. Enter your name while the other fields are optional. Click Continue.

10
Select Gmail as the template type, choose the Gmail draft you just created and then click the Run Mail merge button to send your emails.

Select Gmail as the template type, choose the Gmail draft you just created and then click the Run Mail merge button to send your emails.

11

You can get the Mail Merge Add-on from goo.gl/AnQhdK (Chrome store). Watch the YouTube video demo at youtu.be/F07Py7sraDg to learn more about Mail Merge. For help, email amit@labnol.org

keyboard shortcuts:     previous step     next step
Comments
0 COMMENTS
View More Comments