What is Yet Another Mail Merge and how can I use it?

Yet Another Mail Merge (YAMM) is an easy to use Gmail add-on for users to perform a mail merge. Select a draft written in Gmail, replace template keys with names and other information from the spreadsheet and automatically send personalized emails to up to 1,500 recipients per day.  Follow the steps below to use this add-on.

1. Draft the email message in your University Gmail
2. Open a new Google Sheet
        a. If you've already created a template for mail merge, you can open that Google Sheet.
            You may also use this new sheet as a template for future mail merges that will require similar information
3. Format the new Sheet with your desired information
        a. Example: create a column for name, email address, etc.  Click here for more details about formatting
            
4. When the mail merge formatting is complete, click Add-ons > Yet Another Mail Merge > Start Mail Merge
   
5. Click Continue and choose your UNC Charlotte email address to send from, when prompted
   
        a. If this is your first time, click Accept when asked for permission to access your email and related items
            
6. Select the desired Draft from the drop-down menu and enter the appropriate information
   
7. Click Send Emails
8. A progress bar will display until all emails have been sent and the confirmation message is displayed
        a.  Note that a new column will be added to your Google Sheet to show Merge status that the
            email was sent to that recipient.  You will also see how many emails remain for the day
   
9. Click OK