On Thursday, we sent out an email about how to use Gmail’s Multi-Send feature. It quickly came to our attention that this feature was replaced very recently with the more advanced “mail merge” feature. Mail merge has all of the same benefits of multi-send and is a much better option than mass BCC emails.
Mail merge allows you to link a Google Sheet with up to 1,500 recipients and use any data column from the Sheet as a mail merge tag. Contact information must be in the first tab of your spreadsheet and can only contain text. Here’s how to use mail merge:
- On your computer, open Gmail.
- At the top left, click Compose.
- You can also open an existing draft.
- Go to the “To:” line.
- Click Use mail merge:
- Turn on Mail merge.
- Click Add from a spreadsheet.
- Select a Google Sheet, then click Insert.
- Use the dropdown menus to select the columns from the spreadsheet to determine each recipient’s address (e.g. Lisa Rodriguez <firstname.lastname@example.org>). You can choose the following contact information from your spreadsheet:
- First name
- Last name (optional)
- Click Finish.
- Your spreadsheet is added to the “To:” line in the message.
- In your message, enter “@.”
- Select a merge tag.
- Merge tags are determined by the column headers in your spreadsheet.
- To select a merge tag, press Enter.
Thank you to everyone who sent us their feedback on this recent tip. Of course, as always the SJSU IT Service Desk is here to help by phone at (408) 924-1530 or online.
Vice President for Information Technology
and CIO at San José State University