Environment
U-M Google
Issue
Is there a way to do a mail merge with U-M Google Mail (Gmail) that is easy to use, and within U-M Google?
Resolution
Note: As of February 2024,
according to YAMM, they are "progressively releasing a major upgrade to [their] YAMM dashboard." They are "changing the interface and you might see a discrepancy between the screenshots in the[ir] documentation and what you have in the dashboard." They have not released details on what the changes will look like or if they will change any functionality with the service.
Yet Another Mail Merge (YAMM) lets you select a draft written in Gmail, replace template keys with names and other information from the spreadsheet and automatically send the email. Also, users can configure the add-on to notify one or more email addresses whenever a form is submitted. Another option will send an email to an address submitted by the form.
- Install Yet Another Mail Merge software by going to: https://yamm.com/
- Click on the Install button
- Follow the instructions to add the plugin
- You can link with your U-M Google account
- On the "Untitled Spread Sheet" (if never done) Click "continue" on the "Let's get started" window
- Accept the "request to allow the app to:"
- Click "Add-ons," "Yet Another Mail Merge," "Start Mail Merge"
- Select the dropdown menu
- Select the group you wish to send mail to
- Select "OK" from the pop-up
- The Contacts will import and you will be able to personalize them
NOTE: If you cannot send the 1500 mails, you may need to go to
https://yamm.com/ and sign in with Google to associate your UMICH account with the enterprise license.
Additional Information
- The University of Michigan currently has a site license for YAMM.
- The maximum emails that can be sent are 1500 per day. This is a Google limit and cannot be changed.
- Some have noted that they needed to be in INCOGNITO MODE for their merge to work correctly.
- Do not change the format of the columns from the default sheets. This will cause the mail merge to fail.
- Do not use Formulas or Scripts in the sheets. This will cause the mail merge to fail.
Need additional information or assistance? Contact the ITS Service Center.