How to Mail Merge Avery Labels using Google Docs & Google Sheets 

Install link: workspace.google.com/marketplace/app/create_print_labels_label_maker_for_aver/585829216542

Thank you, this was EXTREMELY helpful!!

Make sure you read the fine print and how much they are going to charge you. It's all about that $$$

After I click on 'create labels', 'open document' does not appear. What am I doing wrong? Help!

Is there a free version beyond the trial. I love this, but don't use it often enough for a paid version.

So helpful. Thank you!

are you able to print out labels with images on them? Instead of names and addresses, I inserted a pdf image of labels I created on canva, but I don't know how to or if its possible to print them into labels with this.

The formatting is not correct for my labels, even though I selected the proper Avery size. The print for the label starts to go outside the rectangle , even after I doublechecked my printer settings, and they are what is specified. Out of a page of 60 labels, I have maybe 16 that I can use. :(. Any help for this?

how can you make sure the formatting doesn't change after merging. I just merged and have a really long name and it changed the size of my labels...defeating the whole reason I wanted to use label maker...to make sure they were formatted correctly

This doesn't work anymore

Very helpful

Thank You!

In Google Docs, how do I delete a blank page (how do I prevent the blank pages from appearing again), how do I lock formatting on/to a specific page, how do I lock the formatting for/on the entire document, how do I select and use a font like wingdings, how do I wrap text to the cell of a table, how do I drag and re-size tables as needed without them messing up the next page?

Want to have a curved rectangle shape in design of label. When I add a shape to the label (in front or behind text) -it doesn't not show up when I select "create labels" even though I can see it in the template. Note I am also using a table within the first cell as there is a lot of detail in the label. The table shows up OR the shape but not both when put together. I can't find anything on this! Help!! TIA

Make sure you look at the "permissions" . You will be agreeing to allow the app to: " See, edit, create, and delete all your Google Docs documents See, edit, create, and delete only the specific Google Drive files you use with this app See, edit, create, and delete all your Google Sheets spreadsheets Display and run third-party web content in prompts and sidebars inside Google applications See your primary Google Account email address See your personal info, including any personal info you've made publicly available"

Can I add an optional Address Line 2 that will only show if that address has a line 2?

When I click on 'select a template' there's nothing there. I tried typing in an Avery code ref, that doesn't work either. Any suggestions?

What if I need to add more blank labels? How do I add more pages of labels below the ones that already generate?

But how do you print addresses on envelopes?

images dont come through just blank boxes?

i am absolutely stuck. I did create the arrows for the name and address does not create the labels. I am so lost.

the select a spreadsheet option is no where to be seen.

It is only free for the first 50 labels. :(

My Fiance: Good luck with printing out labels. It's going to take forever to format! Me: hehehe