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 the Avery Label Merge add-on to print addresses on envelopes from Google Docs or Sheets

Introduction

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, including how to print envelopes in Google Docs and Google 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 Google Docs envelope template box and open the Avery Label Merge sidebar.

Step 2: Choose your source data

From the Avery Label Merge sidebar, click 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 your Google Drive, Shared Drives or any other file you have access to.

Step 3: Select your Sheet

From the Sheet drop-down, select the tab in your Google Sheet containing the data that you want to mail merge envelopes 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 Google Docs envelope template.

To be able to mail merge envelopes, you need to have at least one row of data under your column names.

Step 5: Browse envelope templates in Google Docs

Click the Label / Envelope field to display a list of envelope templates in Google Docs.

Step 6: Choose an envelope template in Google Docs

Select an envelope template in Google Docs from the list and click 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 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 clicking in the desired location within the envelope address 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 in Google Docs

Format your *|merge fields|* as required.

You can change the font, color, size, etc. of the *|merge fields|* in your Google Docs envelope template in the same way you would regular text. You can further customize your envelope template in Google Docs with advanced formatting and images.

Step 10: Make envelopes in Google Docs

Click Merge Labels to mail merge envelopes.

This will make envelopes in a new Google Doc. You will also have the option to download your envelopes in PDF format.

Step 11: Print envelopes in Google Docs

In your newly created envelope document, click the Print icon to print addresses on envelopes.

Your envelopes will now print.

This concludes the steps detailing how to print on envelopes in Google Docs. Thank you for using the Avery Label Merge online label maker add-on. For additional guidance, please visit our Help section.

From the Google Sheets Add-on

Step 1: Choose your source data

Open the Google Sheet containing the data you want to mail merge envelopes 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 mail merge envelopes, 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 envelope addresss 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 address templates.

Step 5: Choose an envelope template

Select an envelope address 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 address 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. 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 will need to clear/delete the date/time values.

Step 8: Make envelopes in Google Docs

Click Merge Labels to mail merge envelopes.

This will make envelopes in a new Google Doc.

Step 9: Print envelopes in Google Docs

In your newly created envelope document, click the Print icon to print addresses on envelopes.

Your envelopes will now print.

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, please visit our Help section.

Envelope Address Templates

The following envelope address templates are available for the 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