Group items tagged

Step 1: Assuming that your already have a Gmail account, go to your Google Contacts and create a new Group (let's say "Media"). Add all the contacts to this group who you want to send a personalized email. Step 2: Create a copy of this spreadsheet into your own Google Docs account. Step 3: You'll see a new "Mail Merge" menu in Google Docs near "Help." Click "Import Gmail Contacts" and authorize Google Docs to access your Google Contacts. Step 4: Click Mail Merge -> Import Gmail Contacts again and type the name of the Gmail group ("Media") that you created in Step 1. Google Docs will now automatically import the relevant Gmail contacts into the spreadsheet.

"A couple of days ago I received a question about sharing Google Drive files. The person who emailed me wanted to know if there is an easier way to share with a group than typing each person's email address individually. The answer is yes. The method is to create a contact group in your Gmail settings (personal Gmail or GAFE). "

Google A-Z Anything missing? Contact me at pbeens@gmail.com or @pbeens. Thanks! This document is now simultaneously published as a webpage at http://goo.gl/qBPWy. (better for embedding or when there are a high number of viewers)