I discovered a new tool this summer that has me super excited because it has solved a major limitation in studio email communication. It’s a Google Sheets Add-On called “Yet Another Mail Merge.” Sounds sexy, doesn’t it?
The Painful Way to Send Studio Emails
Have you ever had to send and email to your whole studio where most of the information was general (maybe an announcement about an upcoming recital), but you also had information that was specific to each student (maybe a list of the music they were going to perform)?
In the past, my process for tackling this task went something like this:
- Write a general email
- Copy and paste the email into a new draft
- Add the personalized info
- Enter the proper email address
- Click send
- Repeat steps 2-5 over and over and over again
Inevitably during this process, I would make at least one mistake. I’d forget to add the personalized notes or (more likely) I’d accidentally send Emma’s song choices to Sophie and cause a student (and/or parent) freak out.
Well, those days are over. Thanks to Yet Another Mail Merge. Or YAMM, as the converts call it.
The YAMM Way to Send Studio Emails
Now my process looks like this:
- Write a general email in Gmail
- Create a spreadsheet with the pertinent custom info
- Start the mail merge
- Carry on with my life
Yeah. That’s it.
YAMM merges all that customized info into the general email to create a perfectly-crafted, personalized email for each student and delivers it to their inbox as if I sent it directly through my email account.
It’s a thing of beauty.
And in case that’s not awesome enough, you can also see who has opened the email you sent. You can tell those parents who somehow miss every email that you’re on to them…
Besides awesome, what exactly is YAMM?!?!
Yet Another Mail Merge is an Add-On for Google Sheets (the Google version of Excel). You can use it with any Gmail address and it’s FREE! There is a paid version available, but the features of the free version are enough for me.
I can think of so many ways music teachers could use this tool for easier studio email communication. These are just a few:
- Recital announcements
- Notifications for mass schedule changes
- Student progress reports
- Audition time slot announcements
So have you changed your mind? Tell me Yet Another Mail Merge isn’t sexy now.