Automating Emails to Families with YAMM

Several weeks ago I published a post exploring the tasks teachers can effectively automate, and in the days after posting it I participated on an episode of the Modern Classrooms Podcast discussing strategies for managing grading in which we touched on the topic of parent communication. Looking back, I can't believe I overlooked parent communication in my automation post, and in particular the incredible mail merge tool I use, YAMM (Yet Another Mail Merge).

For those unfamiliar with mail merges, YAMM integrates with the Google Sheet I use to keep track of which lessons my students have completed, allowing me to send an email with text from one cell to an email address in another cell. The magic happens when YAMM replicates this action row by row, so for each student in my spreadsheet, a unique email is sent to their parents - their name is in Column A, the number of lessons they've completed is in Column B, and their parent email address(es) are in Column C, and YAMM goes down the list, sending emails to the parents that say "[Column A] has completed [Column B] lessons," filling in the template with each student and their completion. It took a bit of work to put the parent emails in and to write up an email draft, but that preliminary work was significantly less than the time it would take me to send an individual email to every parent even just once, and having set it up I can now easily repeat the mail merge weekly!

Sending a personalized email to 151 families is simple with YAMM - this is the entirety of its user interface!

YAMM checks nearly all of my boxes for a "good" automation:

• It allows me to quickly and easily complete a repetitive task only once, taking care of the repetitions for me (in this case, it sends an email to over 200 parents with a single click)
• It integrates with what I'm already using (Google Sheets, in this case)
• It saves me massive amounts of time (literally hours) requiring only a small investment of time on the front end to set it up
• The email is personalized, providing individualized information without asking parents to look up their own students' progress elsewhere (also, the email is technically sent by me, not by YAMM, so parents can reply to me directly)

YAMM has improved my parent communication dramatically, perhaps more than any other tool or strategy I've employed or been taught. Reaching out to families is such an important aspect of teaching other people's children, but it can be daunting or even intimidating for new teachers, especially when we have bad news. The families who receive automated emails from YAMM are under no impression that the message is personally written by me, but I would argue that this actually softens the blow of receiving bad news because it is objective, and parents are consistently appreciative of the bi-weekly progress reports I send telling them how their child is performing. And, because the information goes out to all parents, I can focus my efforts on more personalized communication with the parents of students who need more support, or send notes of congratulations to students who are excelling.

Several good things happen when I send out a mail merge. First, I quickly get back several replies from parents who simply thank me for the information, or let me know they'll talk with their child, or otherwise express their appreciation without asking me for anything more. Second, I get responses from parents who ask me how they can help, how they can engage with their child's learning in my class, and this allows me the opportunity to clarify what the student needs to do and to engage in dialog with families. And finally, in the one or two days after I send out a progress report with YAMM, I see a flurry of submissions - students who were behind work extra hard to catch up, while others go back and revise lessons they hadn't completed or made mistakes on. Some students even reach out to me to ask for help; whether they saw the report and were motivated to reach out themselves or were pressured by their parents doesn't matter to me - this level of engagement and buy-in with my class (triggered solely by the simple progress reports) is unprecedented for me, and I simply can't envision any possible way I could have achieved this level of frequent and consistent family communication (and the benefits that came with it) without automating the progress reports home.

Finally, the mere fact of generating these progress reports means that my pedagogy must be data-driven in order for there to be a spreadsheet from which to generate a progress report in the first place. I've written before about how I structure my gradebook as a progress tracker, but in addition to a strong pedagogical-philosophical approach to educational record-keeping, it also facilitates clear and objective progress reporting, without which my YAMM emails would be much more ambiguous and likely less useful.

YAMM, I should point out, is not free. I am fortunate that my school (a public charter school) pays for my subscription, and I think there's a pretty rock-solid argument to be made that it's worth the small investment, given the benefits. There are other mail merge options as well, although I am not familiar with them.

Reflecting on my own practice, it occurs to me that this automation has become such an integral part of my teaching workflow that I didn't even think to include it in my post on automation. But YAMM is such a simple tool that takes a task I would have to repeat literally hundreds of times and reduces it to a 5-minute task I can do almost mindlessly on a Friday afternoon. If there's interest I might make a tutorial - this is a practice I think teachers, particularly new teachers, would benefit from greatly.