How to do mail merge with Yet Another Mail Merge (Gmail & a spreadsheet)

For more information and support, go to this webpage :

With Yet Another Mail Merge, easily send personalized emails or newsletters to a list of recipients without the need to know how to write HTML for your templates.
Write your own template as a draft in Gmail or use the predesigned template that is available, send test emails and track the opened emails in real time thanks to a very simple user interface.

Yet Another Mail Merge works with Google Accounts (including Google Apps for Work, Google apps for Education and Google Apps for Government).
You can use it to improve your communication with students, parents and colleagues, with your customers or to reach a broader audience if you own a business, or simply to email your family and friends. As an email marketer, if you need to send newsletters or promotional emails, you can use the predesigned template we show in this video tutorial. Personalizing the subject line and email body can increase your open rate.

The add-on is really simple to use. You just need Gmail and a Google Spreadsheet.
In a Spreadsheet, create columns containing specific data you want to put in the emails (names, cities, different greetings for each recipient..., and of course the recipients’ email addresses).
In Gmail, write a draft that will become your template. Every time you need to insert specific data from the Spreadsheet, just copy the column header and paste it in the draft where it’s supposed to appear, using simple markers.
In the Spreadsheet, simply start the add-on. It will ask you to select the column with the email addresses, then select your draft, write how you want your name to appear as the sender, and start the mail merge!
All the markers will be replaced by the data in your spreadsheet, and recipients will receive a personalized email.

[Charles-yqvv]

How did you get a 12-year-old Bjork to introduce your software like that?!

[PanpicVn]

Great. Simple and working well. Thank you so much

[shadiezzz]

Hi, if I were to purchase the personal plan which cost 24$ per year that increases the limit to sending out 400 emails per day, and the information from google shows that the Gmail mail server itself has a send limit of approximately 100-150 emails per day when connected to the server from a remote email client.
So the question is, purchasing the personal plan from the add on itself will allow me to send extra emails out per day, or I would have to pay more cost for Gmail server itself to do that.

[PabloPazosGutierrez]

this is not working on firefox or chrome

I have 2 question, pls explain to me:
- if i send many emails, will gmail server bring my account to spam folder, because the spam filter system is very strong.
- I tried with 3 emails, 1 is Gmail, the rest is others non-google acc, it only tracked Gmail, didn't work for the rest.

[TheKrisKai]

Awesome product!

Just to check if I can add images directly from my computer rather than from a url?

[david-bellaiche]

Hi, great tools!
I'm wondering...how risky is it to use YAMM with my e-mail address (from my domain) ?
Should I create a Gmail address for this?

[geoffsolomon]

Get somebody with a voice that is bearable to listen to.

[GigaBuzzStore]

Trying to find out if automatic follow-up available

[annettehickman]

Thank you Romain this is a top notch add-on. Is there a way to automate each entry? I would like YAMM to merge every time a submission is made.

[valeriadmitrieva]

hello! we paid for 2 YAMM accounts, but haven't receive any conformation of purchase. Please, help us to receive it)

[alaaaljarad]

Hello, Quick question how can I get the email template?! Thanks

[muneerbhuiyan]

Can we insert pictures from googlesheet into mail using mail merge?

[FlyingToasterOven]

This is awful- hard to understand and not well explained