TechSpecks
  • Home
  • Blog
  • Tyler's Tech Tips
  • About
  • Digital Illustration
    • Introduction
    • Module One
    • Module Two
    • Module Three
    • Conclusion
  • Snow and Ice
  • Home
  • Blog
  • Tyler's Tech Tips
  • About
  • Digital Illustration
    • Introduction
    • Module One
    • Module Two
    • Module Three
    • Conclusion
  • Snow and Ice
Tech Specs

Mail Merging with Google Forms

12/4/2015

0 Comments

 
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!!
​
0 Comments



Leave a Reply.

    Picture

    Author

    Tyler Leipprandt - Instructional Technology Consultant at Huron ISD, Google fan, COFFEE, father of 3 little ones, and husband of a BEAutiful wife.

    Archives

    April 2016
    March 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015

    RSS Feed

Proudly powered by Weebly