Merge to Letters
How to 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.
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 best mail merge for Google Docs
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 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: Type mail merge templateÂ
Type your Google Docs mail merge template.
This serves as the basis for your online mail merge to letters.
Step 2: Start Mail Merge add-on
Start Mail Merge add-on by clicking on Extensions > Mail Merge > Start to open the Mail Merge sidebar.
Step 3: Select source data
From the Mail Merge sidebar, click on Open Spreadsheet, and then select 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 Google sheet
From the Sheet drop-down menu, select the tab in your Google sheet that you want to mail merge data from.
Step 5: Check source data
Make sure the first row in your Google sheet contains column names (Name, Address, Email, etc). 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.
Step 6: Insert and format text or *|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 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.
Step 7: Open Options dialog box
Once you have inserted all of your *|merge fields|*, click on Options to open the dialog box.
Step 8: Select between single or multiple merged documents
 Select either Multiple Documents or Single Document from the Merge Letters Into drop-down menu.
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 file names
If you selected Single Document, proceed to Step 10.
If you selected Multiple Documents, two additional drop-down menus 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 preferences
Click on Save to apply the changes.
Step 11: Mail merge letters
Select Letters from the Merge To list, and then click on Merge to start the mail merge process.
Why the Quicklution Mail Merge add-on is the best mail merge for Google Docs:
Easy mail merge installation and free mail merge for your first 20 merges
Free mail merge online support for both free and premium customers, including 24/7 fast remote support, how to mail merge help and FAQs, and video tutorials
Over 5 million users, over 20,000 reviews and a rating of 4.9/5 on Google Workspace Marketplace, and customers that include Google, Uber, and Tripadvisor
Create a mail merge online using one add-on for Google Docs, Google Sheets, Google Slides, and Google Forms, and enjoy seamless integration with Gmail and Google Drive
Easy mail merge from Google apps to emails, letters, envelopes, certificates, and PDF files (anytime and anywhere using your favorite web browser and operating system)
Create your mail merge to emails with images, QR codes, barcodes, hyperlinks, file link attachments, or personalized PDF attachments
Free mail merge to Gmail at scheduled times, automatically on a Google form submit, on behalf of someone else, or over SMTP
Managing your online mail merge is easy with useful tools such as filtering and tracking rows to merge
Check out the other add-ons of Quicklution for Google Workspace, including Avery Label Merge add-on.