Print Addresses on Envelopes

Print addresses on #10 envelopes (or any other) with existing templates from the Avery Label Merge Google Docs Add-on.

Step 1: Install the 'Avery Label Merge' add-on

  • Click the 'Install' button from the add-on's page in the Google Workspace

  • The add-on will be available from Google Docs or Google Sheets after you finish the install wizard.

  • To start the add-on from Add-ons -> Avery Label Merge -> Start

Step 2: Choose your source of data

  • [This step can be skipped if you are printing identical addresses on your envelopes.]

  • From the sidebar click “Select Spreadsheet” to choose a Google Sheet file from which you want to merge data. You can choose any file you have access to include files from another Google Drive or Shared Drive.

  • Make sure the first row in your sheet contains column names. Such as ‘Fullname’, ‘Address’, etc.

Step 3: Choose an Envelope Template

  • Click the default 'Avery 5160' template to change to an other template.

  • Choose the desired envelope size such as #10.

  • When you do so the Label/Envelope Template box changes to the size of the chosen template.

Step 4: Design and format your envelope template

  • In the template envelope box insert your text, images, tables and *|Merge Fields|* as required.

  • Format your text with any color, size and font.

  • More info here

Step 5: Print or make envelopes in Google Docs

  • Hit the blue 'Merge Labels' button if you want to mail merge data from a Google Sheet.

  • Hit the blue 'Identical Labels' button if you do not need to import data from a Google Sheet but just print the same address on your envelopes.

  • A new Google Docs is then created with the list of envelopes. You can also download a PDF version of it.

  • Open this newly created document and go to File -> Print in order to print on your envelopes in your printer.

  • Make sure you have the right printer settings.

Supported Envelopes

  • Print Envelope #10 in Google Docs

  • Print Envelope #6 3/4, #9, #11, #12, #14 in Google Docs

  • Print Envelope B4, B5, B6, C3, C4, C5, C6, C65, DL, E4, E5, E6, E65, Italian, Monarch, US Legal, US Letter in Google Docs