- Go to your contacts list online – export the mail list to Google.csv format – save to the desktop
- Open Word, Mailings, Start Mail Merge, Labels (pick the correct label)
- 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
- Click on Finish and Merge – Edit individual Documents – select all
- Check out the results, print when ready
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
Subscribe to:
Post Comments (Atom)
Thank you, thank you, thank you...
ReplyDelete