Print Address on Envelopes
From Google Docs
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 the Avery Label Merge add-on to print on envelopes from Google Docs or Sheets
From the Google Docs Add-on
Step 1: Start Avery Label Merge
Start the Avery Label Merge add-on by clicking Add-ons > Avery Label Merge > Start.
This will display the template and open the Avery Label Merge sidebar.
Step 2: Choose your source of data
From the Avery Label Merge sidebar, click Select Spreadsheet and choose the Google Sheets file from which you want to merge data.
This can be a file from your Google Drive, Team Drives or any other Google Drive you have access to.
Step 3: Select your Sheet
From the Sheet drop-down, select the tab in your Google Sheet that you want to merge data from.
Step 4: Check your source data
Make sure the first row in your Google Sheet contains column names, such as Name, Address, City State, Zip Code etc. These column names will be used as *|merge fields|* in your envelope template.
To be able to merge, you need to have at least one row of data under your column names.
Step 5: Browse envelope templates
Click the Label / Envelope field to display a list of envelope templates.
Step 6: Choose an envelope template
Select an envelope template from the list and click Apply.
You can search by envelope type, size, description and more.
Once a template is selected, the template box changes to the size of the chosen envelope template.
Step 7: Add a return address
Add a return address, if required.
Step 8: Add your *|merge fields|*
Position your text centrally on the envelope template using the ruler and the Enter key and then insert your *|merge fields|* 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.
Step 9: Design and format your envelope template
Format your *|merge fields|* as required.
You can change the font, color, size, etc. of the *|merge fields|* in your envelope template in the same way you would regular text. You can further customize your envelope template with advanced formatting and images.
Step 10: Create your envelopes in Google Docs
Click Merge Labels to begin the envelope merge process.
This will create a Google Doc containing your envelopes. You will also have the option to download your envelopes in PDF format.
Step 11: Print or make envelopes in Google Docs
In your newly created envelope document, click the Print icon to print your envelopes.
From the Google Sheets Add-on
Step 1: Choose your source of data
Open the Google Sheet you want to merge from.
Make sure the first row in your sheet contains column names, such as Name, Address, City State, Zip Code etc. These column names will be used as *|merge fields|* in your envelope template.
To be able to merge, you need to have at least one row of data under your column names.
Step 2: Start Avery Label Merge
Start the Avery Label Merge add-on by clicking Extensions > Avery Label Merge > Start.
This will open the Avery Label Merge dialog box.
Step 3: Add your *|merge fields|*
Insert *|merge fields|* into your envelope 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.
Step 4: Browse envelope templates
Click the Label / Envelope field to display a list of envelope templates.
Step 5: Choose an envelope template
Select an envelope template from the list and click Apply.
You can search by envelope type, size, description and more.
Step 6: Design and format your envelope template
Format your *|merge fields|* as required.
You can change the font, color, size, etc. of the *|merge fields|* in your envelope template in the same way you would regular text. You can further customize your envelope template by adding images.
Step 7: Filter rows
Click Filter Rows.
This will create a new column in your sheet called Filter Rows to Merge. Following the mail merge, 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 will need to clear/delete the date/time values.
Step 8: Create your envelopes in Google Docs
Click Merge Labels to begin the envelope merge process.
This will create a Google Doc containing your envelopes. You will also have the option to download your envelopes in PDF format.
Step 9: Print or make envelopes in Google Docs
In your newly created envelope document, click the Print icon to print your merged envelopes.
Supported Envelopes
The following envelope types are supported by the Avery Label Merge add-on:
#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