Mail Merging with Google Forms

Most of us all have heard of mail merging before, but like myself, have never knew how to perform one....or why you would want to perform one.  Mail merging allows you to create letters, name tags, etc., using a single spreadsheet with information stored on it.  Instead of hand typing a personalized letter to each of your students, a mail merge can let you type up a template letter.  Your template letter can then be customized from information you have on your spreadsheet.  

In the video below, I am going to show how to have the responses from a Google Form be instantly emailed back to the person who submitted the Google Form.  Why is this helpful?  In many different situations, the individual who submits a form would like to have confirmation of what they submitted.  For example, if a person submitted an application, they may want confirmation that it went through and would like a record of what they submitted.  In the classroom, teachers could use this for confirmation of: book checkouts, parent communication, mass emailing of information, reminders for conference meeting times, etc.

I have known for a short time that Google Forms could be used with a mail merge, so here is my attempt to explain if to you.  The easiest way to do this is in a 11  minute video, but here are the basic steps:

• Create a Google Form or use an existing one.
• Open your response spreadsheet tied to the Google Form.
• Use the "Add-On" formMule
• Customize the mail merge to your liking.
• Sit back, relax, and let your mail merge do tedious work for you!!

​