This script will use the most recent draft in Gmail as a template.
- Handles duplicate entries (by email address)
- Works with HTML and plain text emails
- Open Spreadsheet
- Go to
Tools > Script editor... - Paste contents of
mailmerge.gsthere - Save it
- After saving script, you will notice a new menu Mail Merege in Spreadsheet
- From Spreadsheet, Go to
Mail Merge > Send mail
| First name | Last name | |
|---|---|---|
| Abc | Xyz | [email protected] |
| Def | Pqr | [email protected] |
To: Email (here, put the title of email column)
Body:
Hello {{First name}} {{Last name}}...
To: [email protected]
Body:
Hello Abc Xyz...
MIT