Top 100

Monday, February 2, 2015

Mail Merge in Google Sheets

If you're a teacher and have a collection of emails for students or parents then this tip may help you communicate with them better.  Yet Another Mail Merge works like this:

1. Download the free script in a Google Sheet
2. Start an email in your Gmail account and include an easy-to-copy code inside your message to personalize it (like this: Hello $%First Name$, welcome to class.)  That code tells the Google to pull the data from your sheet and put them in the email.
3. Go back to your Google Sheet and run the mail merge

The mail will be sent to all of the recipients with your personalized message.  Why would you do this instead of sending the mail and just dropping all of the recipients in one mail?  The personalization aspect is useful as is the general ease of use.

The free version lets you send 100 emails per day.  Check out the video below to see it in action.


2 comments:

  1. How can you buy more emails per day?

    ReplyDelete
    Replies
    1. Go here https://sites.google.com/site/scriptsexamples/available-web-apps/mail-merge/pricing

      Delete