If you need to print labels from Google Docs, there is a add-in that you can add to Google Docs called "Avery Label Merge." The add-on will allow you to create a mail merge by entering names and/or address information into a Google Sheet, and then use the Avery Label Merge add-on in a Google Doc to create an Avery label and then print the labels.
- while in a Google document, click on the Add-Ons menu
- click on Get Add-Ons
- search for "Avery Label Merge" or use this link Avery Label Merge plug in
- click the blue Free button
- a window will pop up. Scroll to the bottom of that window and click the Accept button
- some basic instructions will appear on your document
- when you're ready,
- create your mail merge content in a Google Sheet. Make sure you label the column headers in the first row (eg. first name last name address etc.)
- open a new Google document
- click on the Add-Ons menu
- choose Avery Label Merge
- choose New Merge
- click on either Address Labels or Name Badges
- choose the Avery label or badge that you want
- choose the spreadsheet that has the mail merge information
- put your cursor in the box that appears
- click column header names on the sidebar to insert them into the box, putting in spaces and returns where appropriate
- click Merge on the sidebar when you're done
- when the "created document" window appears, click on the Open button
- You will need to use Google Chrome
- The merge content is limited to 999 entries (Thanks to Katie Little for figuring this out!)
This Add-On does not appear to work in a Team Drive. When I try to connect to a spreadsheet the add-on looks inside My Drive for spreadsheets..
Please sign in to leave a comment.