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