Yet Another Mail Merge (YAMM)
Yet Another Mail Merge (YAMM) is a Google Sheets extension that works with Gmail to send personalised emails to multiple recipients. It’s the University’s preferred option for low to medium volume email merges.
YAMM sends emails using Gmail accounts, using their multi-send quota. This means you can send emails to up to 1,500 recipients per 24 hours. (Other third-party mail merge services that can provide a larger quota because they use their own email servers. However, this introduces security issues.)
Key features
- Drafts containing 'placeholders' are merged with addresses and other data in a Google Sheet to generate and send multiple, personalised emails.
- Schedule mailings up to two weeks in advance.
- Include email attachments and unsubscribe links.
- Send customised automated emails on a Google Form submission (yet-another-mail-merge.com).
- The status of each merged email is displayed on the spreadsheet list. So you can track which have been sent, opened, and whether any links within the email have been clicked.
- Merge jobs are processed hourly – set it going and leave it to get on with it.
- Create polls (yet-another-mail-merge.com) and track responses through the original data sheet.
- Download and use simple templates from the YAMM Dashboard (legacy.app.yamm.com).
Before sending out mailings to large groups of people, please read 'Do you need email merge?' for advice on alternative ways of getting your message out. Plus, read the University policy for bulk emailing.
Access instructions
- Access YAMM through the Extensions menu in Google Sheets, when logged into your University Google account.
- It requires you to sign in to Google.
- If you are using a Google Sheet that has been uploaded as an Excel format (.xlsx), you will need to convert this to a Google Sheet before the extensions menu will appear. Go to File, and choose Save as Google Sheets.
Related tools
- Google Gmail
- Mailjet (for external recipients only)
- Google Groups
- Student Enquiry Screen
- More communication, collaboration and productivity tools
Additional information
Do you need email merge?
Do you need email merge?
Mail merge was originally designed to generate personalised printed letters and mailing labels or envelopes. When the same model was applied to email it became possible to send merged email to thousands of recipients with very little effort.
This has been one of the drivers for the development of laws and directives to prevent us all being swamped with unsolicited emails, and it is particularly important to consider this if you plan on using email merge for marketing purposes.
Within the University, there is a policy for bulk emailing, which is aimed at eliminating unnecessary emails to staff and students, and this should always be consulted before undertaking email merge. For staff, general contact with students can often be achieved using the Student Enquiry Screen.
The emphasis in recent years has been to put control into the hands of the recipient, not the sender, and to seek engagement and conversation rather than a passive information distribution. Email merge is not the best tool for this.
What are the alternatives?
Mail merge is all about sending something, but thinking about possible alternatives requires a different mindset. Here are some examples; one thing they have in common is they put the recipient much more in the driving seat, and make it easy for them to unsubscribe should they wish:
- Social media is one way of getting messages out to people. In IT Services, we tweet about service disruption, new facilities etc, and we know that students and staff appreciate this.
- Google Groups enable you to create relevant groups of people (eg all staff in your department, all students on a module). You can send emails to the Group, and group members can control how they receive posts sent to the group. Groups can also be used as a discussion forum, and for sharing files on Google Drive.
- A public blog will let you post news items on a regular basis, and so has some similarity to a traditional newsletter, with several important advantages:
- You can post small items more frequently, so recipients are more likely to read it all.
- The blog will contain all previous news items, not just the latest, so you can make links between them, and viewers can easily read earlier posts.
- News items can be tagged with topical keywords, making it easy to locate news items covering similar topics.
- Blogs are designed so they are conveniently readable on mobile devices as well as desktop computers.
- Blogs can include a comments section where viewers can add their own contribution.
- You could also send less frequent merged emails (or tweets) to highlight news items and provide a link to encourage people to visit and read your blog.
Still want to email merge?
If you've considered the alternatives, but concluded that you really do need email merge, and once you have checked that your activity is GDPR compliant, Yet Another Mail Merge (YAMM) is the preferred option for low to medium volume email merge at the University.