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))
 Helpful  Not helpful
|