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.
Print Envelope #10 in Google Docs