Google Email Merge
Would you like to be able to send out the same email message but customized for each recipient, perhaps with name, department, and other recipient-specific details? You can achieve this mail merge function using Google Mail and Google Drive Spreadsheets. Learn how in this training class.
Note: Please refer to the Stony Brook IT Email and Broadcast Email message policies before utilizing this email merge technique.
Audience: Faculty, Researchers, Staff and Teaching Assistants
Workshop Level: Advanced
At The End Of This Workshop You Will Be Able To
Prepare a Spreadsheet of Data To Use for the Mail Merge
Create the Mail Merge Template in Google Mail
Send out Mail Merge Emails
Current Workshop Schedule
This workshop is not currently scheduled. Please contact us to schedule a session for you.
Resources
Browse presentation slides or view a previous session.
Resources
Note that as of 4/23/14, to use the method described in the video and presentation, use this template, which already has the script installed, and follow these directions: Mail Merge in Google Mail with a Google Sheet
Learn More About These Services
Google Mail
Google Mail is the preferred email system at Stony Brook University for faculty, staff, and students on West Campus, Southampton, Manhattan, and select departments within the Health Sciences Center.
Members of Stony Brook Medicine, including Stony Brook Hospital and the School of Dental Medicine, will continue to use Microsoft Exchange for email due to HIPAA compliance requirements.
Google Drive
Google Drive provides a single place to store, create, sync, and share documents, files, and folders of all types. Access files anywhere - at your desk, from home, or on a mobile device.
Broadcast Email Messaging
The Division of Information Technology (DoIT) is responsible for distributing broadcast email messages. Requests must be pre-approved by a relevant Vice President, Department Head, or the CIO.
DoIT Training and Development
- doit_training@stonybrook.edu
- (631) 632-9800
- Website