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:

  1. Write a general email
  2. Copy and paste the email into a new draft
  3. Add the personalized info
  4. Enter the proper email address
  5. Click send
  6. 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:

  1. Write a general email in Gmail
  2. Create a spreadsheet with the pertinent custom info
  3. Start the mail merge
  4. 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.

Other Uses

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.

You can get Yet Another Mail Merge here and check out the documentation for help with setup.

How else have you simplified your studio email communication?

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.

Menu