Embedded Files
How to mail merge addresses on envelopes from Google Docs?
Change the Google document page size to your required envelope size (e.g., Envelope Size 10). Insert your return address at the top and the shipping address *|merge fields|* in the middle. Link to a Google sheet from which to merge data and then you are ready to merge and print your envelopes through your home or office printer.
Change the Google document page size to your required envelope size (e.g., Envelope Size 10). Insert your return address at the top and the shipping address *|merge fields|* in the middle. Link to a Google sheet from which to merge data and then you are ready to merge and print your envelopes through your home or office printer.
Video tutorial
Video tutorial
Watch this quick tutorial or follow the step-by-step instructions below to find out how to print on envelopes.Â
Introduction to best mail merge for envelopes
Introduction to best mail merge for envelopes
The 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 customize your own Google Docs envelope template, including creating envelopes with return addresses.
How to mail merge envelopes from a Google sheet.
How to print envelopes at home/office, including how to print envelopes in Google Docs.
Step 1: Create envelopes
Step 1: Create envelopes
To start the process to print envelopes in Google Docs, click on Extensions > Mail Merge > Envelopes to open the Envelope Size dialog box.
Step 2: Select envelope size
Step 2: Select envelope size
To set up your envelope template in Google Docs, select a template from the Envelope Size drop-down menu, and then click on Save. A popular type is Envelope #10.
Alternatively, you can select Custom Size from the drop-down menu, and then specify the Width and Height of your envelope address template in the boxes provided.
Step 3: Start Mail Merge add-on
Step 3: Start Mail Merge add-on
Start Mail Merge add-on by clicking on Extensions > Mail Merge > Start to open the Mail Merge sidebar.
Step 4: Select source data
Step 4: Select source data
From the Mail Merge sidebar, click on Open Spreadsheet, and then select the Google Sheets file from which you want to 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 5: Select Google sheet
Step 5: Select Google sheet
From the Sheet drop-down menu, select the tab in your Google sheet that you want to merge data from.
Step 6: Add return addresses to envelopes
Step 6: Add return addresses to envelopes
If you wish to make envelopes with return addresses, add a return address in the top-left corner.
Step 7: Insert and format text or *|merge fields|*
Step 7: Insert and format text or *|merge fields|*
Position your text centrally on the Google Docs envelope template using the ruler and the Enter key, insert your *|merge fields|* by selecting a field from the Merge Field drop-down menu, and click on Add.
Add all of the *|merge fields|* required to complete your mailing address.
*|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 envelope address template in the same way you would regular text.
Step 8: Mail merge envelopes
Step 8: Mail merge envelopes
To mail merge envelopes, select Letters from the Merge To list, and then click on Merge.
Step 9: Configure envelope print settings
Step 9: Configure envelope print settings
From your newly created Google Document containing your merged envelopes, click on the Print icon to configure your printer to print envelopes.
Step 10: Print envelopes
Step 10: Print envelopes
Click on More Settings, and then select your envelope size from the Paper Size drop-down menu. This only shows the page sizes compatible with the selected printer.
To create your envelopes and send them to your printer, click on Print.
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
Trusted by millions of customers including Google, Uber, and Tripadvisor, UN, Dropbox, Harvard College, DC.GOV, Wyoming State, Hillingdon London, City of Edminton Whirlpool, and many more.
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.
Try Avery Label Merge add-on
Avery Label Merge add-on is specifically designed to create and mail merge envelopes and labels. It provides features suited to label and envelope design such as multi-column layout, which are not found in Mail Merge,.
Try Avery Label Merge today by clicking on the link below.
Report abuse