Create emails including data from your Google Sheet columns. Mail Merge and send these personalised emails with no MMM limits!
Listing updated:January 13, 2024
Works with:
39K+
Overview
Welcome to Magic Mail Merge! 

Magic Mail Merge is mainly designed for teachers to use with their students allowing them to email data from their class tracker as personalised mail merged emails. This add-on can of course be used by anyone to create a mail merged email to anyone recipient of their choice. 

Users can create as many tracking sheets as they require and produce as many different email templates to merge the data to. You can store as many different email templates as you like.

As long as you place your email template in the correct cell on the worksheet you can send whatever emails you like. You can always send a test email to check your mail merge is working correctly before you send it. 

Unlike other add-ons available Magic Mail Merge has no set limits (other than Google's own limits) and will not charge you for this feature. 

PLEASE NOTE GOOGLE LIMITS
https://script.google.com/dashboard

If you are a personal Gmail user then you are limited to 100 emails per day

**NEW FEATURES**
HTML Email Template
Add fields to the Subject of your emails
You can add multiple email addresses to the ‘Email Address’ field by separating each one by a comma
CC & BCC columns - add columns titled CC and BCC in order to add extra email addresses
Customise the sender name for your emails

**NEW RELEASE FEATURES**
ReplyTo columns - add column titled ReplyTo in order to customise who the default reply to will be. 
Add PDF attachments from any Google Drive file - add column titles attachment and put the Google Drive file ID in order to attach them to the email as PDFs. Docs, Sheets, Slides and PDFs will be sent as PDFs. Image files will be sent as images in their original format. 
You can also add multiple attachments in this way, just separate by a comma and no space
Additional information
PricingFree of charge
Privacy policy
Terms of service
Magic Mail Merge will ask for the permissions shown below. Learn more
Magic Mail Merge will need access to your Google account
This will allow Magic Mail Merge to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Kline Elden
October 17, 2023
I needed to send a mail merge email to about 1200 people. MMM made it so easy. The user manual is simple to follow and then it took me only minutes to work out the process of even including multiple attachments. I could even send different attachments to different people. The sent emails all appear in my Sent items in Gmail.
Is this review helpful?
Yes
No
Profile Picture
Rob Corner
May 31, 2023
This is great! I needed to send a mail merge email to about 1200 people. MMM made it so easy. The user manual is simple to follow and then it took me only minutes to work out the process of even including multiple attachments. I could even send different attachments to different people. The sent emails all appear in my Sent items in Gmail. Thanks for such a great tool.
Is this review helpful?
Yes
No
Profile Picture
Nickole Medina
May 23, 2022
I found an email in my husband's Gmail. Funny thing is it was made by some girl and they try to portray it as a loan offer. I started researching fake emails. I think they are talking through emails. Any in put I got a pics of it
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Mail Merge
February 27, 2018
Brilliant addon and works like a charm. You have to edit the email in Google Sheets which adds an extra step, but its super easy and flexible, plus the developer is brilliant at helping with problems/improvements.
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Mail Merge
February 16, 2018
Great App. I used to spend an hour sending a email to each employee, now I can send 150 emails with one click. Also the creator of the app was very helpful when I encountered some issues. Highly recommended.
Is this review helpful?
Yes
No
Profile Picture
Azhar Jameel
December 17, 2020
My an email or Gmail not recaver plz azharjameel55e......g........
Is this review helpful?
Yes
No
1-6 of 6
Search
Clear search
Close search
Google apps
Main menu