Over the past 7 years, the one tech tool that has been reliably my absolute favorite has been . This story walks you through the step by step of how to use it. YAMM, Yet Another Mail Merge 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 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 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 😱. send up to 1,500 Compose If you have ever received 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. State of the Noonion 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 with a header row that includes google spreadsheet 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 If this is the first time you use it might have to restart the computer or reset spreadsheet to see the option) Yet Another Mail Merge ( 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. 😉😉😉

Google

Check out my corner of the internet here 

Read My Stories

Now Hiring

The Pandemic of Childcare

Too Long; Didn't Read

Get free API security automated scan in minutes

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

Too Long; Didn't Read

Company Mentioned

@linh

RELATED STORIES