Print onto Avery labels from within Google Docs
Posted by Patricia Goodman on 26 January 2016 03:49 PM

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"
  • 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
    • it is recommended that you print to plain paper first to make sure it prints correctly
    • when you're ready to print on the labels, you'll need to make sure the print job is pulling from the by-pass (or manual feed) tray:
      • click on File, Print
      • near the bottom of the next window, click on Print using System Dialog
      • choose the by-pass tray (or manual feed tray) from the available settings, and then print

created 1/26/16 pg 


(102 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: