Mail Merge for Gmail

Misha Filip

2021-02-12

This is a simple e-mail merge extension. It works. It has no silly quotas like YAMM. I used it with a Google account and from Google Drive, so it may be different in other circumstances.
However, to get it to work, one needs to ensure the following:
1. the tab in a spreadsheet where the merge data is residing must be the leftmost (first) tab in the spreadsheet. If it is not, it won't find the data.
2. the email addresses must be in the leftmost column of that first tab.
3. take care with tag names, e.g. "First name" must be used exactly like that First name, it is case sensitive, so First Name will not work. This was highlighted in the example provided.
4. A good feature is that one can select which rows to merge and which not to (by ticking/unticking) and any "illegal" rows are "crossed out" so you can decide whether to ignore them or go back to data and fix any issues.
5. the email template gives different results in preview mode (where things look OK) and the actual email received after the merge. The actual mail merge strips all line breaks / carriage returns and turns the text into one long paragraph. I have not played with many HTML formatting options, but when I inserted "br"s in the template text, that looked ugly in the preview, but produced line breaks in the received merged email. I suspect that the text can be HTML formatted to make it look good.
Maybe it's not good enough to use with external clients [it has not got many features] but for internal mailings it looks like it is a good solution.

Liêm Pha Tô

2020-10-28

không thể gửi đi được, cũng không được báo lý dó gì mà không gửi được luôn

Matt Foley

2022-06-15

This product is an utter waste of time. Do not waste your time like I did. Walk away. Do not add to Chrome. It DOES NOT FORMAT ANYTHING. My simple 6 paragraph email message turned into a rambling blob of text without the spaces between paragraphs. Also, it DOES NOT HAVE FUNCTIONALITY TO ADD AN ATTACHMENT. It is AWFUL!

carolyn kagan

2022-10-07

Didn't work - not recognising several addresses. Moreover the functionality is so limited that it defeats the object - no provision for attachments or for html clickable links, for example.

Mark Norviel

2023-01-11

The extension works as described. No support, means take it as is. It is basic, no frills. If you review your email content it will look just like you typed it, but when you send the email it will arrive in the recipients in-box as unformatted text all run together. In other words, no line breaks or other formatting. If you want the email text to be formatted you will need to use HTML tags such bold and br etc. A bigger issue in my mind, however, is when you use this mail merge tool, the recipient will either get a warning that the email is dangerous or it will end up in their spam filter.