If you need to send a large number of emails and want the message in the email to change according to the recipient's information, such as the recipient's name, membership number, and membership expiration date, you can send these emails with just one click.
Watch this video for instructions on using Mail Merge to send emails to a large number of recipients: https://youtu.be/WA3dH5jS8sc
Mail Merge from Gmail allows you to send multiple emails with a single click.
Here are the steps:
Prepare the data you want to send in a Google Sheet, using English column names.
Go to Gmail > Compose > To: > click the Use mail merge icon > select From a spreadsheet > select the file you prepared.
In the Email field, select the @email column.
In the First Name field, select @Name.
The system will show a preview of all the recipients > Once you have entered all the information, click Finish.
The To field will show the spreadsheet of the senders > then enter the Subject name.
In the content section, type a message and insert the @ symbol followed by the name of the column you want. Then you can send the email.
Each recipient will receive a unique copy of the email, according to the details in the spreadsheet.
Note: You can use the Mail Merge feature with the following Google Workspace editions:
Business Standard
Business Plus
Enterprise Starter
Enterprise Standard
Enterprise Plus
Education Standard
Education Plus
留言