Create & Print Envelopes

How do I 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 you are ready to merge and print your envelopes through your home or office printer.

Watch a Video Tutorial

Watch this quick tutorial or follow the step-by-step instructions below to find out how to print on envelopes.

Introduction to the 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 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 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: Make your envelopes

To start the process to print envelopes in Google Docs, click Extensions > Mail Merge > Envelopes.

This will open the Envelope Size dialog box.

Step 2: Select your envelope size

To setup your envelope template in Google Docs, select a template from the Envelope Size drop-down and then click Save. A popular type is Envelope #10.

Alternatively, you can select Custom Size from the drop-down and then specify the Width and Height of your envelope address template in the boxes provided.

Step 3: Start the Mail Merge add-on

Click Extensions > Mail Merge > Start.

This will open the Mail Merge sidebar, from where you can mail merge envelopes.

Step 4: Select your source data

From the Mail Merge sidebar, click Open Spreadsheet and choose 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 your Sheet

From the Sheet drop-down, select the tab in your Google Sheet that you want to merge data from.

Step 6: Add return addresses to your envelopes

If you wish to make envelopes with return addresses, add a return address in the top-left corner.

Step 7: Add your merge fields

Position your text centrally on the Google Docs envelope template using the ruler and the Enter key and then insert your *|merge fields|* by selecting a field from the Merge Field drop-down and clicking 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 your envelopes

To mail merge envelopes, select Letters under Merge To and then click the Merge button.

Step 9: Configure your envelope print settings

From your newly created Google Document containing your merged envelopes, click the Print icon to configure your printer ready to print envelopes.

Step 10: Print your envelopes

Click More Settings and select your envelope size from the Paper Size drop-down. This will only show the page sizes compatible with the selected printer.

To create your envelopes and send them to your printer, click the Print button.

Congratulations! You now know how to print addresses on envelopes by merging data from Google Sheets. Printing envelopes from Google Sheets is as easy as it gets.

Why the Quicklution Mail Merge add-on is the best mail merge for Google Docs:

Check out Quicklution's online mail merge add-ons for Google Workspace, including Avery Label Merge.

Try Avery Label Merge

Avery Label Merge is a fully-fledged add-on specifically designed to create and mail merge envelopes and labels. This tool provides features suited to label and envelope design which are not found in Mail Merge, such as a multi-column layout.

You can try Avery Label Merge today by clicking on the link below.