Topics Map > IT Operations > Customer Support and Policies > E-mail
Topics Map > IT Operations > Customer Support and Policies > Google Suite
Yet Another Mail Merge
Yet Another Mail Merge (YAMM) is an add-on to Google Sheets available to @umd GSuite users. It provides an easy way to send out up to 1,500 emails per day. It has useful additional features, such as tailoring certain details of the mass emails to users, including a clickable button to a link (such as making a simple Yes/No response), and tracking the progress of the email (how much it is read).
You can watch a quick overview here, to learn more.
YAMM functions by having you make your draft email, then putting the contacts into a Google Sheet. If your email includes customized data, can then customize certain details of the email in the google sheet to each contact, if you choose to.
Steps to installing YAMM can be found here. Instructions on using it from your regular UMD account can be found here.
How to use Yet Another Mail Merge with a Google Shared Account:
Some of the functionality will come from your own UMD google account, so read carefully!
- Using these IT Support Instructions first, configure "send as" from your @umd.edu account to send-as the Google Shared Inbox address in question.
- For example, if I am trying to send-as "eit-itops@umd.edu," I must configure that from my own @umd.edu account settings.
- For example, if I am trying to send-as "eit-itops@umd.edu," I must configure that from my own @umd.edu account settings.
- Then, from your @umd.edu account, create the template you'd like to use for your mail merge, and save it:
- Install YAMM from here using your @umd.edu account.
- Create or open your Google Sheet containing your mail merge information. This can be done from any UMD Google Sheet, regardless of whether it is stored in your own UMD Google Drive, or in a UMD Shared GDrive. In our example, we're using a sheet out of the "IT Operations" shared Google drive.
- From the spreadsheet with your data, start up YAMM:
- Click on "+ Alias, filters, personalized attachments...". Select the Google Shared Inbox address as the "Send From" and set the "Reply-to address" if you'd like replies to go to that Shared Inbox:
- Click "Back," choose the Email template to use, and then "Send" to start the mail merge.
- The emails will send as the "Sender Name," with the email Template you chose, "from" the "Send From:" address you chose in the YAMM alias settings window.
