Printing labels using the free Google office suite can seem tricky at first, but once you know how, it’s not so intimidating. Yesterday, we showed you how to create a document and install the Avery Mail Merge add-on.  Then we created a spreadsheet for our addresses. If you haven’t done that yet, you’ll want to click here to check out part 1 of this tip.

Click the Add-ons tab in your document and choose Avery Label Merge. Then click New Merge.

google-doc-avery-label-merge-inew-merge

Select Address Labels.

google-doc-select-avery-merge

 

Then choose which label you’ll be using.

google-doc-select-avery-merge-type

 

Choose the spreadsheet you wish to use.

google-doc-choose-spreadsheet

Click in the doc text box.

google-doc-cursor-in-box

From the panel that opens at the right choose the column headers you want to be added to the labels.

google-doc-column-header

They’ll be added to the text box. Make sure to space them as shown.

google-doc-names-stacked

Then click

google-doc-name-merge

The addresses will then appear in the label document.

google-names-printed

That was a lot of steps, but the next time you do it, most of the work will already be done.

~ Cynthia