Merge to Emails
How do I merge to email using Google Docs?
Mail merge to emails (powered by Gmail) using a Google Document as your email body template or as a personalized PDF attachment.
Watch a Video Tutorial
Watch this quick tutorial or follow the step-by-step instructions below to find out how to mail merge from Google Docs to emails.
Introduction to the best mail merge for Gmail
The Mail Merge add-on is free to install, works from four Google Workspace apps, benefits from free 24/7 support and is packed with useful features which make mail merge easy. All of this means that Mail Merge is the best mail merge add-on available.
The steps below detail:
How to create a mail merge template in Google Docs
How to mail merge from Google Docs for free
How to email mail merge to Gmail for free
Step 1: Create your mail merge template in Google Docs
Write your Google Docs mail merge template.
This will serve as the basis for your online mail merge to emails.
Step 2: Start the Google Docs Mail Merge add-on
Start the Mail Merge add-on by clicking Extensions > Mail Merge > Start.
This will open the Mail Merge sidebar.
Step 3: Select your source data
From the Mail Merge sidebar, click Open Spreadsheet and choose the Google Sheets data file from which you want to mail merge to Gmail.
This can be a file from your Google Drive, Shared Drives or any other file you have access to.
You can import your Google Contacts into a Google Sheet by following the steps in this article.
Step 4: Select your Sheet
From the Sheet drop-down, select the tab in your Google Sheet that you want to mail merge to email from.
Step 5: Check your source data in Google Sheets
Make sure the first row in your Google Sheet contains column names, such as Name, Address, Email, etc. These column names will be used as *|merge fields|* in your Google Docs mail merge template.
To be able to mail merge to Gmail, you need to have at least one row of data under your column names.
Step 6: Add your *|merge fields|*
Insert *|merge fields|* into your Google Docs mail merge template by clicking in the desired location within the template, selecting a field from the Merge Field drop-down and clicking Add.
Repeat this step for all required *|merge fields|*.
*|Merge fields|* are the column names found in the first row of data in your Google Sheet. You can change the font, color, size, etc. of the *|merge fields|* in your Google Docs mail merge template in the same way you would regular text. You can further customize your email mail merge template by adding images, file attachments and hyperlinks.
Step 7: Configure your mail merge to email
Click Show Email Settings and:
In the Email To drop-down select the column containing the recipient's email address. Multiple email addresses can be used for each To receipent.
Enter your Email Subject, such as 'Confirm Contact Details.' You can even insert a merge field into the email subject, e.g. 'Confirm Contact Details for *|Name|*'.
Step 8: Mail merge to create your emails
Once you have inserted all of your *|merge fields|*, you have three options:
A. Merge to a Test Email: This will give you a good idea of how your email merge will appear to recipients, before sending emails. It will merge the first row of data in your sheet (that is row 2 since row 1 only contains column headers).
B. Merge to Emails: This will mail merge to Gmail and send all of your emails straight away.
C. Merge to Gmail's Draft Folder: This will mail merge to Gmail's draft folder and give you the opportunity to check and edit your email merge before you send it.
Select one of the three options above and, when you are ready, press the Merge button to start the email merge process from the Mail Merge add-on.
Congratulations! You now know how to mail merge from Google Docs to emails and how to mail merge to Gmail using the best mail merge for free!
Why the Quicklution Mail Merge add-on is the best mail merge for Google Docs: