Print Address on Envelopes
From Google Docs & Sheets
Print addresses on #10 envelopes (or any other) with existing templates from the Avery Label Merge Google Docs Add-on.
Get this labelmaker directly from Google Marketplace: Install Avery Label Merge add-on to print addresses on envelopes from Google Docs or Sheets
Introduction
The steps below detail:
How to customize a 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, including how to print envelopes in Google Docs and Google Sheets.
From the Google Docs Add-on
Step 1: Start Avery Label Merge
Start Avery Label Merge add-on by clicking on Extensions > Avery Label Merge > Start to display the Google Docs envelope template box and open the Avery Label Merge sidebar.
Step 2: Select source data
From the Avery Label Merge sidebar, click on Select Spreadsheet and choose the Google Sheets file containg the data from which you want to mail merge envelopes.
This can be a file from Google Drive, Shared Drives, or any other file you have access to.
You can import Google Contacts into a Google Sheet by following the steps in this article.
Step 3: Select Google Sheets tab
From the Sheet drop-down menu, select the tab in the Google Sheet containing the data that you want to mail merge envelopes from.
Step 4: Check source data
Make sure the first row in the Google Sheet contains column names, such as Name, Address, City State, Zip Code etc. These column names are going to be used as *|merge fields|* in the Google Docs envelope template.
To be able to mail merge envelopes, you need to have at least one row of data under the column names.
Step 5: Browse envelope templates in Google Docs
Click on the Label / Envelope field to display a list of envelope templates in Google Docs.
Step 6: Select envelope template in Google Docs
Select an envelope template in Google Docs from the list and click on Apply.
You can search by envelope type, size, description and more.
Once a template is selected, the Google Docs envelope template box changes to the size of the chosen envelope address template.
Step 7: Make envelopes with return addresses
Add a return address, if you require envelopes with return addresses.
Envelopes with return addresses can easily be returned to the sender if they cannot be delivered to the recipient. Moreover, envelopes with return addresses also help to identify the sender to the recipient.
Step 8: Add *|merge fields|*
Position the text centrally in the Google Docs envelope template using the ruler and the Enter key and then insert the *|merge fields|* by clicking in the desired location within the envelope address 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 the Google Sheet.
Step 9: Design and format envelope template in Google Docs
Format *|merge fields|* as required.
You can change the font, color, size, etc. of the *|merge fields|* in Google Docs envelope template in the same way you would regular text. You can further customize an envelope template in Google Docs with advanced formatting and images.
Step 10: Make envelopes in Google Docs
Click on Merge Labels to mail merge envelopes.
This creates envelopes in a new Google Doc. There is also an option to download the envelopes in PDF format.
Step 11: Print envelopes
In the newly created envelope document, click on the Print icon to print addresses on envelopes.
This concludes the steps detailing how to print on envelopes in Google Docs. For additional guidance, visit our Help section.
From the Google Sheets Add-on
Step 1: Select source data
Open the Google Sheet containing the data you want to mail merge envelopes from.
Make sure the first row in the Google sheet contains column names, such as Name, Address, City State, Zip Code etc. These column names are going to be used as *|merge fields|* in the envelope template.
To be able to mail merge envelopes, you need to have at least one row of data under the column names.
Step 2: Start Avery Label Merge add-on
Start Avery Label Merge add-on by clicking on Extensions > Avery Label Merge > Start to open the Avery Label Merge dialog box.
Step 3: Add *|merge fields|*
Insert *|merge fields|* into the envelope template by clicking in the desired location within the envelope addresss template, selecting a field from the Merge Field drop-down 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 the Google sheet.
Step 4: Browse envelope templates
Click on the Label / Envelope field to display a list of envelope address templates.
Step 5: Select envelope template
Select an envelope address template from the list and click on Apply.
You can search by envelope type, size, description, and more.
Step 6: Design and format envelope template
Format the *|merge fields|* as required.
You can change the font, color, size, etc. of the *|merge fields|* in the envelope address template in the same way you would regular text. You can further customize the envelope template by adding images.
Step 7: Filter rows
Click on Filter Rows.
This creates a new column in the Google sheet called Filter Rows to Merge. When you mail merge envelopes, the empty cells in the Filter Rows to Merge column are populated with the date/time the merge took place. To merge these rows again, you need to clear/delete the date/time values.
Step 8: Create envelopes in Google Docs
Click on Merge Labels to mail merge envelopes.
This creates envelopes in a new Google Doc.
Step 9: Print envelopes
In the newly created envelope document, click on the Print icon to print addresses on envelopes.
This concludes the steps detailing how to print addresses on envelopes in Google Sheets. Thank you for using the Avery Label Merge online label maker add-on. For additional guidance, visit our Help section.
Envelope Address Templates
The following envelope address templates are available for Avery Label Merge add-on to print envelopes in Google Docs and Google Sheets:
#6 3/4
#9
#10
#11
#12
#14
B4
B5
B6
C3
C4
C5
C6
C65
DL
E4
E5
E6
E65
Italian
Monarch
US Legal
US Letter