Merge to Letters
How do I merge to letters from Google Docs?
Write a Google Document template and mail merge to letters. Either merge all letters into a single Google Doc or a document for every merged row. For the latter, you can opt to generate a PDF version of the merged document.
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 letters.
Introduction to the best mail merge for Google Docs
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 for your letters
How to mail merge from Google Docs with a Google Sheet
How to mail merge using Google Docs 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 letters.
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 file from which you want to mail merge data.
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 data 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 merge, 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 letter mail merge template by adding images.
Step 7: Open the options dialog box
Once you have inserted all of your *|merge fields|*, open the Options window by clicking the button in the Mail Merge sidebar.
Step 8: Choose between single or multiple merged documents
Select either Multiple Documents or Single Document from the Merge Letters Into drop-down.
This gives you the option to create a new file for every row or to merge all rows into a single file.
Step 9: Configure your file names
If you selected Single Document, proceed to Step 10.
If you selected Multiple Documents, two additional drop-downs become available:
Merged Document Name: This enables you to set one of your *|merge fields|* as the file name for your merged documents.
Save to PDF: This gives you the option to create a copy of your merged documents in PDF format, in addition to the default Google Docs format.
Step 10: Save your preferences
Click Save to apply changes.
Step 11: Mail merge to create your letters
Select Letters from Merge To and, when you are ready, press the Merge button to start the Google Docs mail merge to letters process.
Congratulations! You now know how to mail merge to letters from Google Docs using the best mail merge for free!
Why the Quicklution Mail Merge add-on is the best mail merge for Google Docs: