How to send thousands of personalized emails like a pro and not a creep

cover
9 Aug 2021
Over the past 7 years, the one tech tool that has been reliably my absolute favorite has been YAMM, Yet Another Mail Merge. This story walks you through the step by step of how to use it.
Disclaimer: no this is not a shill piece for yamm as they did not pay me for it even though they probably might as well at this point, just saying.

About Yet Another Mail Merge.

YAMM is a tool that allows you to send up to 1,500 totally customizable emails with amazing open & click rate per every 24 hours. This happens because from the receiver's vantage point, the email looks like you hit the
Compose
button and send directly to them and just them. Yet, from the sender's end, it saves hours (literally) of you having to copy paste a body of text tens if not hundreds/thousands of times, while having to find that custom field to replace, and still sometimes making weird formatting mistake or even more substantial mistakes such as addressing them by the wrong name 😱.
If you have ever received State of the Noonion letter or the multiple hiring emails I sent over the years, THOSE ARE YAMMS! In fact, most of the emails you receive from me that looks kinda nice, it’s probably a yamm lol.
Okay - pitch over (honestly they should just commission me), onto the how to do it.

Step by step how to Yamm

Step 1: Create a google spreadsheet with a header row that includes Email

  • Each email needs to be a different row. Email cannot be empty.
  • Can include as many custom fields in the header as you want, such as Name, Company Name, URL, special note etc...
  • Looks like this (order is not important)

Step 2: Install Yamm as a google sheet Add-on

  • Click
    Add-ons
  • Click
    Manage Add-ons
  • Search for YAMM Yet Another Mail Merge
  • Do an Individual Install
  • The free version gives you 50 daily emails but I recommend the paid version. Up to you.

Step 3: Create the Email draft in Gmail

  • Compose email like you would do normally
  • Customize field by using this symbol
    << >>
  • Here's how it could look
Basically, whichever info you want to customize, put it in between the
 << >>

Step 4: Test send to make sure your email doesn't look weird

  • Click Add-ons
  • Click Yet Another Mail Merge (If this is the first time you use it might have to restart the computer or reset spreadsheet to see the option)
  • Click Start Mail Merge
  • Pro-tip: sign out of all your other Gmail inboxes and only the inbox you are sending the email from.
  • A pop up will appear that looks like this:
  • Then, click
    Email Template
  • Select the draft that you just composed
  • Click
    Send Test Email
  • Find the email in your inbox and read through it
  • Fix what needs to be fixed.

Step 5: Final touch up and send for real!

  • Fix some more and test some more until you are happy with the results
  • When you're finally happy with it, click Send x Emails (it will tell you exactly how many emails you have in your database)
  • This is when I usually get my adrenaline, especially if you send closer to 1.5k emails. SO COOL. It will take somewhere between 1 minute to 30 minutes to send depending on how many emails you send!
  • How it looks:
    • And that's it! You are done!
    • You will see a new column emerged called Merge Status
    • When an email is opened, clicked, or responded to, Merge Status will change. Looks something like this:

    Bonus

    Here's a little Easter Egg gift for you if you read until here, the result of that test email I sent to my team:
    Happy YAMM-ING! Also - yamm - if you happen to see this story, I think it's time to offer me this tool that I've trusted and used for 7 years, for free. I think it's only fair. πŸ˜‰πŸ˜‰πŸ˜‰