Email is still one of the best ways to keep in touch with your supporters and donors. But, sending bulk emails can be very time-consuming. What if you need to quickly send out a personalised email to all your supporters about an event, or about a campaign you're doing to raise money for your project, or even if you need to send out important updates to all your patrons? We know of a simple and free way for you to do just that!

Yet Another Mail Merge (YAMM) is an email campaigning tool that combines the magic of Gmail and Google Sheets to help you send hundreds of personalised emails with a click of a button! You can even track who has opened your emails and follow up with those who haven't checked.

How to install:

You can find YAMM in the Google Sheets add-ons store or click HERE. Hit the "+ FREE" button to add it to your Google Sheets.

How to use:

Import contacts:

First, you will need to import all the contacts part of the campaign into Google Sheets. To do this, you need to open a new Google Sheet, click on Add-ons > Yet Another Mail Merge > Import contacts. From here you can select from where you would like to import your contacts from.


Any additional information like the First name, Last name, Company, Position, etc. would be helpful to customise your emails to the fullest. Each category must have its own column and column header.

Draft your template:

You will need to create a template for your message. Just type in your message, leave the 'To' field empty, and save it as a draft. You can also use one of YAMM's many pre-designed templates for various scenarios.


Personalise your email:

To personalise your email, you need to add 'Markers' and markers are usually the column headers from your Google Sheet that are written within double curly brackets: {{Column Header}}.


So, for example, you want your email to address each recipient's first name, all you have to do is type in {{First Name}} in the place you want their name to appear.


This only works if the marker matches your column headers.


Send your message:

To send out the email template you just created, go to the Google Sheet with all your campaign contacts, and click on Add-ons > Yet Another Mail Merge > Start Mail Merge.

At this point, you will get a popup where you need to add the sender's name (you, your company, etc.) and select the email template (lists your drafts). If you want to be able to track your campaign, make sure the tracking option box is checked. To send your emails out immediately, click on the "Send Emails" button. Or if you want to schedule them to go out at another date or time, click on the "Delay delivery" button.


Once your campaign begins, you cannot stop the emails from going out so be sure to double check your message and contacts list before you initiate it.

Schedule options:

Your emails can be scheduled at any time up to 7 days in advance. When you choose the "Delay delivery" option, you get a popup where you can select the time and date of the delivery.


Track your campaign:

You can track your campaign in real time with YAMM. Once your emails are sent out, you can see how many of those sent emails were opened, how many clicked links in your email, how many unsubscribed, etc.


Pricing Plans:

Free account: Send up to 50 emails every 24 hours with Gmail and G Suite accounts.
Paid account for Gmail: Send up to 400 emails every 24 hours.
Paid account for G Suite: Send up to 1500 emails every 24 hours.

All plans are billed annually.

YAMM is a great tool you can try today for FREE. If you want to know more about it, feel free to ask us in the comments section below or by sending us an email at [email protected]