Skip to content Accessibility statement
Home>IT Services>Tools, software and services>Yet Another Mail Merge (YAMM)

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.

Available to staff and students

You can use this service on University-managed and personal devices.

Web-based

This service works in your web browser.

Funded by the University

There isn’t a cost to you for standard use.

Additional information

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.

Guides and help

How-to guides and set up

  • YAMM support - get started (yet-another-mail-merge.com)
    • Ignore the installation instructions as YAMM is already installed on University accounts.

Training and best practice

See the supplier's documentation:

We also offer training and guidance at York:

Accessibility

If using email templates created through tables in Google Docs, these may prove inconvenient for recipients using a screen-reader as it will read out the layout of the table, even if hidden.

Consider adding a disclaimer for “if you require this information in an alternative format, please contact [email address].”

Contact for support

If you're experiencing technical issues and need advice, please contact IT Services.

Service commitments

Page last reviewed: 9 September 2024