Thursday, August 25, 2011

Printing Mailing Labels from Google Contacts with Word 2010

I've written about this before, but I think I have an approach that uses less steps.  Once it's set up, it's just a three step process


  1. Go to your contacts list online – export the mail list to Google.csv format – save to the desktop
  2. Open Word, Mailings, Start Mail Merge, Labels (pick the correct label)
  3. Select Receipents, Use Existing List, Pick the Google.csv file you downloaded, Comma Separators
    • These steps only need to be done the first time
    • Insert Merge Field: Name - (on the next line): Address_1__Formatted
    • Click on Update Labels
    • Save this document -- you'll just reload it next time and skip all this first time stuff
  4. Click on Finish and Merge – Edit individual Documents – select all
  5. Check out the results, print when ready

1 Comments - yours are welcome:

  1. Thank you, thank you, thank you...

    ReplyDelete