harshjv / gmail-mail-merge

⚡️ Google Script for Mail Merge using Spreadsheet and Gmail

⚡️ Mail Merge using Spreadsheet and Gmail

This script will use the most recent draft in Gmail as a template.

Features

• Handles duplicate entries (by email address)
• Works with HTML and plain text emails

Usage

1. Open Spreadsheet
2. Go to Tools > Script editor...
3. Paste contents of mailmerge.gs there
4. Save it
5. After saving script, you will notice a new menu Mail Merege in Spreadsheet
6. From Spreadsheet, Go to Mail Merge > Send mail

Example Spreadsheet

First name	Last name	Email
Abc	Xyz	[email protected]
Def	Pqr	[email protected]

Template

To: Email (here, put the title of email column)
Body:
Hello {{First name}} {{Last name}}...

Email Outcome

To: [email protected]
Body:
Hello Abc Xyz...

License

MIT

gmail-mail-merge's Issues

Trim Error

Message details
TypeError: Cannot call method "trim" of undefined.

Images included in original draft are not sent correctly

I am guessing it has to do with how mail merge grabs the draft, but embedded images do not make it to the final destination.

A work around is to use an

<img>

tag in the excel sheet and have mailmerge replace some title (e.g. {{image}}) with the desired image.

doesn't replace {{Last name}}

Please help me.