Merge to Letters

Watch this quick tutorial or follow the step-by-step instructions below to find out how to mail merge from Google Sheets to letters.

Mail Merge add-on is free to install and try. It works from Google Docs, Google Sheets, Google Slides and Google Forms, benefits from free 24/7 support, and 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.

In the Google sheet you use for merging to letters, make sure the first row contains column names (e.g., Email Address). These column names are used as *|merge fields|* in your Google Docs mail merge template.

To be able to merge, you need to have at least one row of data under your column names.

Start Mail Merge add-on by clicking on Extensions > Mail Merge > Start to open the Mail Merge dialog box. A new column called Filter Rows to Merge is created automatically.

Click on Select From Drive to select your saved Google Docs mail merge template, or click on Create Sample to create a new Google Docs mail merge template. 

The Google Docs mail merge template serves as the basis for your mail merge to letters.

In Google Docs mail merge template, start Mail Merge add-on by clicking on Extensions > Mail Merge > Start to open the Mail Merge side bar.

If your Google Spreadsheet does not automatically appear, click on Open Spreadsheet, and then select your file as needed.

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 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 your Google Docs mail merge template in the same way you would regular text. You can further customize your letter mail merge template by adding images.

 Select either Single Document or Multiple Documents from the Merge Letters Into drop-down menu.

This gives you the option to merge all rows into a single file or to create a new file for every row.

If you select Single Document, two additional drop-down menus become available:

• Add Page Break: This gives you the option to either repeat a template in a page or add page breaks between the template.

• Batch Size: This gives you the option to merge in small batches (e.g., 80-100 rows) if you have many rows to merge, otherwise an error occurs. Type 0 to not merge in small batches. 

If you select Multiple Documents, two additional drop-down menus become available:

• Merged Document Name: This gives you the option to select a name for merged files. 

• Save to PDF: This gives you the option to create a PDF file along with the Google Docs file. Applicable only when Multiple Documents is selected for Merge Letters Into. 

Click on Merge Letters to start the mail merge process. The settings are automatically saved.

Click on Yes to merge to letters. 

For the rows you want to merge again, delete the date and time information in the cells in the Filter Rows to Merge column.