Sep 6, 2019

how do you create mailing labels aka Avery labels in docs?

I've tried to create labels to print in docs.
Locked
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies (12)
Hi, Debie,
 
To merge and print labels (which you can affix to envelopes), please try one of these free options: Avery Easy Merge for Google Drive or Avery Design & Print Online.
 
~Jo
Sep 9, 2019
Jo, 
Just installed and tried to use it, but this is the message I get when launching it to use:

Sign in with Google temporarily disabled for this app
This app has not been verified yet by Google in order to use Google Sign In.

Any suggestions?
Hi, Lynn,
 
Try Avery Design & Print Online instead. Does that work for you? 
 
If it doesn't, please contact Avery help. Since this is a third-party app, any problems would need to be addressed by them directly.
 
Please report back and let me know how it goes!
 
~Jo
Actually, Lynn, it looks like Avery added back their add-on for merging in Docs! It had previously been deprecated, so this is great news!
 
It's called Mail Merge for Avery Labels. You can get it by going to Add-ons (in the tool bar) > Get add-ons and then searching for it by name.
 
Once you find it, just press the blue Free button to add it to Docs. You can then access it by clicking on Add-ons in the tool bar to display all the add-ons you have.
 
Does that resolve it for you?
 
~Jo
 
I looked at that add-on again, Lynn, and it appears that it isn't from Avery but another third party, and there's a subscription fee required.

A free option is the add-on called Mail Merge Contacts.

I'd still suggest trying Avery Design & Print Online (which is free). I'd love to know how either of these work out for you.

~Jo
Sep 9, 2019
Yes, the online did work 👍
Great! Thanks for letting me know, Lynn! I'm glad you have a good solution in place now.
 
~Jo
Sep 18, 2019
Hello, I have searched for both of the add-ons suggested here.  I'm not finding either one, but many others purporting to send out mass emails.  I need to print labels, pretty desperately for actual snail mail on envelopes!  To be clear, I have a mailing list in Google sheets, and I need to print labels from that list.  For an upcoming funeral... for my husband.  Please help.
Hi, Pamela,
 
To do a merge, you can try the add-on for Docs called Mail Merge for Avery Labels (this is a fee-based add-on) or Mail Merge Contacts (which is free). You can get them by going to Add-ons (in the tool bar) > Get add-ons and then searching for them by name.
 
Once you find them, just press the blue Free button to add it to Docs. You can then access them by clicking on Add-ons in the tool bar to display all the add-ons you have.
 
Another option is the merge feature in Avery Design & Print Online (which is free).
 
~Jo
Dec 8, 2019
I'm lost somewhere on this forum topic... I need to create mailing labels from my Google Sheets, not Google Docs.   Could somebody please set me in the correct direction.  TIA
Hi, Kenneth,
 
As your question differs from the original poster's, please start a new thread in the Docs help forum so we can try to address your particular issue. Please also include whether you're on a mobile or desktop device and your operating system and browser.
 
Here's a direct link for your convenience:
 
 
Scroll down and select "Ask now" on the bottom right.
 
~Jo
Google Product Expert Volunteer (not a Google employee)
Jan 14, 2020
none of these are obvious or work or are free
false
14686260676971747230
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false