Merge to Emails

Mail Merge add-on is free to install, works from four Google Workspace apps, benefits from free 24/7 support, and it is packed with useful features that make mail merging 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

Type the Google Docs mail merge template for the online mail merge to emails.

Start Mail Merge add-on by clicking on Extensions > Mail Merge > Start to open the Mail Merge sidebar.

From the Sheet drop-down menu, select the tab in the Google sheet that is going to be used to mail merge to Gmail.

Make sure the first row in the Google sheet contains column names (Name, Address, Email, etc.). These column names are used as *|merge fields|* in the Google Docs mail merge template.

To be able to mail merge to Gmail, at least one row of data is needed under the column names.

Insert *|merge fields|* into the Google Docs mail merge template by clicking in the desired location within the template, selecting a field from the Merge Field drop-down menu, and clicking on 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 the Google Docs mail merge template in the same way as regular text. The email mail merge template can be further customized by adding images, file attachments, and hyperlinks.

Click on Show Email Settings and:

• In the Email To drop-down menu, select the column containing the recipient's email address. Multiple email addresses can be used for each To receipent.

• Enter the Email Subject such as Confirm Contact Details. You can also insert a merge field into the email subject (e.g., Confirm Contact Details for *|Name|*).

The mail merge settings can be further customized by scheduling emails, sending emails on behalf of someone else, or sending emails over SMTP.

Select from the following three options, and then click on Merge to start the mail merge process:

A. Merge to a Test Email: This gives a good idea of how the mail merge appears to recipients, before sending emails. It merges the first row of data in the Google sheet (that is row 2 since row 1 only contains column headers).

B. Merge to Emails: This mail merges to Gmail and sends all of the emails straight away.

C. Merge to Gmail's Draft Folder: This mail merges to Gmail's draft folder and it allows the opportunity to check and edit the mail merge before it is sent.