Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

I have a contacts group in Gmail with a haphazard collection of about 900 names. Maybe half of them have addresses associated with them. I would like to print these out on envelopes for a mass mailing. What's the easiest way to accomplish this?

I'm using a Mac and have Microsoft Office, so a process that makes use of the tools I have would be nice.

share|improve this question
What version of Mac OS X? – NSGod Feb 21 '12 at 21:25

Word gives you the option to import contacts from your local address book. Mac OS X's address book gives you the ability sync with Google from 10.5.3 onwards. So:

  1. Open address book
  2. Go to prefences (command + ,)
  3. Select the account tabe
  4. Select your local account
  5. Check synchronize with Google and follow the instructions

In Word, use the mail merge feature under Tools>Mail Merge and select Apple Address Book as the recipient list.

Note that this solution will add these items to your local address book which might not be desirable. It will also temporarily disable iCloud syncing though it can be re-enabled easily enough. A somewhat more complex option is to select Export from the More menu in GMail Contacts. You can then read the CSV file using Open Data Source in Mail Merge.

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.