Using Mail-Merge from a Drive Spreadsheet for Personalized Group Emails in Gmail

| 14 February 2011

14 February 2011

Jacob Stimpson

I found this on Lifehacker, but it can be a pain to search their site, so I’m posting it here, with a tweak I found.

Digital Inspiriation has a great tip on how to do mail-merge in Gmail. They have a Google Doc you can use in conjunction with a contacts group in Gmail, to email the whole group, but with each individual person’s name at the beginning.

I wanted to tweak it slightly though and have it just display a first name, rather than their full name. I found this tweak, where you just edit the script’s code to say “getGivenName” instead of “getFullName”! It works perfectly.

You might also like these blogs and articles


Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to Our Newsletter for Updates

Stay in the loop and receive exclusive offers!

"*" indicates required fields