Google announced a new mail merge feature on June 27, 2023. Here are some initial notes and instructions for the mass email feature using Google Sheets.
There are two options:
- Multi-send. You enter the recipients manually and use default variables @firstname, @lastname, and @email to personalize the message.
- Mail merge with Sheets. You create a spreadsheet with a minimum firstname, lastname, email columns. You can send up to 1500 emails a day.
Before you use the new Gmail merge:
- All recipients must have Lehigh email accounts (sending to external email accounts is not supported).
- In testing mail merge with Sheets, the Preview feature did not seem to work.
Instructions for sending
...
messages via Gmail merge
Note: if you plan to use a Google Sheet recipient list, create the sheet with minimum firstname, lastname, email columns. The column names can be anything you choose.
...