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.
Select Address Labels.
Then choose which label you’ll be using.
Choose the spreadsheet you wish to use.
Click in the doc text box.
From the panel that opens at the right choose the column headers you want to be added to the labels.
They’ll be added to the text box. Make sure to space them as shown.
Then click
The addresses will then appear in the label document.
That was a lot of steps, but the next time you do it, most of the work will already be done.
~ Cynthia