Using YAMM (Yet Another Mail Merge) with U-M Google Mail

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

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.

  1. Go to install the Yet Another Mail Merge app. See: https://yamm.com/
  2. Add the plugin
  3. On the "Untitled Spread Sheet" (if never done) Click "continue" on the "Let's get started" window.
  4. Accept the "request to allow the app to:"
  5. Click "Add-ons," "Yet Another Mail Merge," "Start Mail Merge"
  6. Select the dropdown menu
  7. Select the group you wish to send mail to
  8. Select "OK" from the pop-up
  9. The Contacts will import and you will be able to personalize them

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.
  • 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.
  • 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.

Details

Article ID: 1054
Created
Mon 4/20/20 8:38 AM
Modified
Wed 9/21/22 12:57 PM