Embedded Files
You can use mail merge in Gmail to send,it is possible to insert names and other unique information within the body of an email and send it individually to many destinations.
Each recipient receives a unique copy of the email. Recipients can’t check who else you sent the message to.
There are two ways.
A. Add recipients directly to your message
B. Add recipients from a spreadsheet to your message
Notes & Limits
Notes & Limits
Notes
It is not possible to set a secondary group email address(@mail2.adm.kyoto-u.ac.jp) as the sender address(From address).
A copy of the sent email is created for each recipient. Therefore, attaching files to the email consume a large amount of the sender's storage.
(e.g., if you attach a 10MB file and send it to 300 people, it will use about 3 GB of your Gmail space.)
Limits
Please refer to the following Google Help.
Send personalized emails with mail merge
- Understand send limits
- Understand Cc and Bcc recipient limits
- Unsubscribed recipients
- How to avoid your messages being marked as spam
- Understand mail merge limitations
A. Add recipients directly to your message
A. Add recipients directly to your message
1. Open the Gmail compose window and turn off Plain Text Mode.
Click the “More options” icon at the bottom of the screen and uncheck “Plain text mode”.
2. On the right of the "To:" line, click "Use mail merge".
3. Turn on "Mail Merge".
4. In the "To:" line, add recipients.
<Tips:>
To add multiple recipients, it is helpful to create labels in Google Contacts to group recipients. When you add the label in the "To:" line in Gmail, the grouped recipients populate automatically. Learn how to organize contacts with labels.
5. In your message, enter "@".
Select a merge tag. Press Enter to insert the merge tag.
6. Click “Preview” to review the contents.
<Tips:>
Set the "Set default value".
If you have a recipient with missing information for a merge tag, you can avoid the error.
7. After entering the message, click “Continue” and then "Got it".
8. Clicking "Send All" will send emails in bulk.
The merge tags will be replaced with each recipient's individual information.
Recipient 1
Recipient 2
9. Open the Gmail compose screen and turn on Plain text mode.
Click the “More options” icon at the bottom of the screen and check “Plain text mode”.
Close the New Message.
*Usually, please use e-mail in plain text mode.
<Tips:> Please stop sending HTML mails
B. Add recipients from a spreadsheet to your message
B. Add recipients from a spreadsheet to your message
1. Open the Gmail compose window and turn off Plain Text Mode.
Click the “More options” icon at the bottom of the screen and uncheck “Plain text mode”.
2. On the right of the "To:" line, click "Use mail merge".
3. Turn on "Mail Merge".
4. Click "Add from a spreadsheet".
5. Select the spreadsheet with the recipient's information and click "Insert".
Example of spreadsheet entry
6. In the window, select the columns from your spreadsheet that have recipient info(Email,First name,Last name (optional)).
Click "Finish".
Your spreadsheet is added to the "To:" line in the message.
7. In your message, enter "@".
Select a merge tag. Press Enter to insert the merge tag.
8. Click “Preview” to review the contents.
<Tips:>
Set the "Set default value".
If you have a recipient with missing information for a merge tag, you can avoid the error.
9. After entering the message, click “Continue” and then "Got it".
10. Clicking "Send All" will send emails in bulk.
The merge tags will be replaced with each recipient's individual information.
Recipient 1
Recipient 2
11. Open the Gmail compose screen and turn on Plain text mode.
Click the “More options” icon at the bottom of the screen and check “Plain text mode”.
Close the New Message.
*Usually, please use e-mail in plain text mode.
<Tips:> Please stop sending HTML mails
Report abuse