Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to create address labels in Google Docs based on my Gmail contacts (even better would be a group of contacts I made)? Essentially allowing me to easily create all my address labels for mailing out invitations or Christmas cards or whatever in just a few steps.

share|improve this question
  1. It seems to me if you use the Print option in the contact manager.
  2. You can select to print just addresses. That opens a new browser window and formats it for printing.
  3. Use 'Ctrl-A' selecting all the information, including headers.
  4. Paste it into Excel.
  5. Save the Excel file.
  6. Run a mail merge using MS Word.

It seems like a lot of steps but it works rather smoothly and doesn't take much time at all. Once in the mail merge labels you can reformat the font just about any way you want.

share|improve this answer
Thanks for those steps. But what I was really looking for was a solution to do this with Google docs. This is definitely the next best solution though. – Jacob Schoen Jul 8 '10 at 11:55

You can use one of the sheets' templates available on Google Drive. Usually are configurated for Avery labels.

Examples (you need to be logged in with a Google account):

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.