In this tutorial, we will show you exactly how to print envelopes from Google Sheets in just a few simple steps. Simply follow the steps below.
Follow the steps below to print on envelopes from Google Sheets.
On your Google Docs, go to Extensions, hover to Add-ons and choose Get add-ons. This will open the Google Workspace Marketplace.
Search for the Mail Merge add-on then install it. Click Allow then continue to approve the necessary permissions. This add-on will merge the data from Google Sheets into your Google Docs envelope.
Open the Mail Merge add-on from your Google Docs, go to Extensions hover to Mail Merge then choose Start. This will load a new window on the right side of the screen.
Click Open Spreadsheet then choose “your Google Sheet” (in this example 'Logbook_US' was the file name of our spreadsheet) finally, click Select. This will load your spreadsheet in the Mail Merge.
Now, select the Sheet to where your data is located, in our case this is ‘InfoBook’.
Insert the needed placeholders by selecting it from the Merge Field dropdown then click Add. Do this until all the necessary placeholders are added.
Now, select Merge to Letters, hover to Merge and click “Yes” (if you still have the trial version informing you about the remaining merge trials). This will now load a new Google Docs file containing your envelopes. Open it, then review for final retouch if needed.
On the file generated by the add-on, go to File menu, then Print. Adjust the printer driver settings accordingly to match your envelope size and margins. This will print your envelopes with varying data based on your Google Sheets file.
We hope that you now have a better understanding on how to print on envelopes from a Google Sheets file. If you enjoyed this article, you might also like our articles on exporting CSV with quotes in Google Sheets and calculating IRR in Google Sheets.
