How to Quickly Email Parents in Multiple Languages

“If you talk to a man in a language he understands, that goes to his head. If you talk to him in his language, that goes to his heart.” – Nelson Mandela

Each week I communicate with the parents of my 200+ students in multiple languages and this has made such a profound impact on student outcomes and relationships! In this post I explain how to use the free Google Sheets add-on,  Form Mule,  to send a personalized email to 100s of parents in multiple languages. Check out my guest post for ESL-Library, Digital Ways to Effectively Communicate with Parents in Multiple Languages, to discover more tips and several recommended free tools for ongoing effective parent communication in multiple languages.

💡Discover more ways to integrate technology effectively by taking one of my fully accredited online courses or get one of my books!

 

Form Mule For Emails in Multiple Languages

Form Mule is such an incredible Google Sheets email merge add-on that allows you to send personalized emails using a spreadsheet and email template. See my visual below for a general idea of how this works.

It may look complicated, but once you set up Form Mule sending 100s and 1000s of parents (if you have a GSuite Edu account) a personalized email in multiple languages takes minutes! To get started you will need the following:

  • a Google account
  • a Google Sheet with the following information in columns with headings- students’ first and last names, parents’ first and last names, the parents’ email addresses, and anything else you want to share in your email that would be different for each student, such as comments, class codes, urls, dates, the home language, grade level, and so forth
  • the Form Mule add-on installed for free on your Google Sheet
  • an email template you want to send to the parents
  • optional– the email template in HTML, because Form Mule is HTML friendly so you can add italics, clickable links, and other customizations
  • optional– the Google Translate language code to send the email in English and another language. For example, I add “es” to the “Lang:” field to translate my email in Spanish. Click here for other language codes.

The following tutorials are super helpful if you experience any difficulties along the way!

  • Click here for the G Suite Marketplace’s gif tutorial and to download.
  • Click here for Edtech Creative’s step by step visual tutorial on how to use Forms, Sheets, and Form Mule to send student grade checks.

Tip for sending in multiple languages! Form Mule allows you to send different email templates for each worksheet created in your spreadsheet. To send the email in more than one other language (ex. Spanish, French, and Korean) you can create a worksheet for each language. Then add “ko” or “fr”to the “Lang:” field for that specific worksheet’s email template.

Challenge: Try Form Mule to send parents or students personalized emails or newsletters in multiple languages!

Subscribe for FREE to receive regular updates!

 

 

Shelly Terrell

Shelly Sanchez Terrell (@ShellTerrell) is an award winning digital innovator, an international speaker/consultant, and the author of Hacking Digital Learning with EdTech Missions, The 30 Goals Challenge for Teachers, and Learning to Go. She has trained teachers and taught English language learners in over 20 countries as an invited guest expert by organizations, like the US Embassy, UNESCO Bangkok, Cultura Inglesa of Brazil, the British Council in Tel Aviv, IATEFL Slovenia, HUPE Croatia, ISTEK Turkey, and Venezuela TESOL. She has been recognized by several organizations and publications as a leader in the movement of teacher driven professional development as the founder and organizer of various online conferences, Twitter chats, and Massive Open Online Courses (MOOCs). Two of the projects she co-organized were shortlisted for ELTons, #ELTChat and the Virtual Round Table Language and Technology online conference. She was named Woman of the Year by the National Association of Professional Women, awarded a Bammy Award as a founder of #Edchat, and named as one of the 10 Most Influential People in EdTech by Tech & Learning. Her greatest joy is being the mother of baby Savannah and Rosco the pug. Shelly has an Honors BA in English with a Minor in Communication and a specialization in Electronic Media from UTSA, a Masters in Curriculum Instruction ESL from the University of Phoenix, and a CELTA from CELT Athens. She regularly shares her tips for effective technology integration via Twitter (@ShellTerrell), Facebook.com/ShellyTerrell, and on her blog, TeacherRebootCamp.com, which has won several awards and recognitions as one of the top ESL, Edtech and Elearning blogs. Find over 400 of her slide presentations at https://www.slideshare.net/ShellTerrell/presentations

2 comments

  1. This is such a helpful article! I hadn’t thought about having to email multiple parents in different languages, but I will be bookmarking this article for when that day arises. Thank you for sharing!

Leave a Reply

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