Your Google Sheet for Mail Merge has a column titled "Email Address" and that column, as the name suggests, contains the list of recipients for that campaign. When you run merge against the sheet, it will send out one email per row in the spreadsheet.
Add Multiple Recipients
If you would like to add more email recipients to your merge campaign, you can simply add more rows in the Google Sheet and each recipient would be sent a separate message.
You can also add multiple recipients in one email message so they all receive the same email message at the same time.
There are two ways to send an email to more than one person in mail merge.
- Use the dynamic CC and BCC option and include the other recipients in the same message but in the CC/BCC fields.
- Add multiple email addresses in the
Email Address column, separated with commas. Each recipient will then be included in the To field of your outgoing email message.
Send to Group Emails
You can send emails to Google Groups, mailing lists or any distribution lists through Mail Merge.
A list can have multiple members and yet, because a single email is sent to the group, it will only reduce your daily quota by one.
When sending to a group, the email cannot be personalized for each recipient and you'll also not be able to track which member of the Gmail group opened or clicked your email.
FAQs
You may send the mail to multiple recipients, by mentioning them in the To, CC, and BCC fields. If you wish to send the notification to the form respondent, check the option that says Notify Form Respondent .
How do I send an email to multiple recipients in mail merge? ›
Add recipients directly to your message
- On your computer, open Gmail.
- At the top left, click Compose. ...
- In the "To:" line, add recipients.
- On the right of the "To:" line, click Use mail merge .
- Turn on Mail Merge.
- In your message, enter @.
- Select a merge tag: ...
- To insert the merge tag, press Enter.
How to send an email to multiple recipients individually in Gmail
- Kick things off. Log into your Gmail account. ...
- Write your message. Time to write that email. ...
- Use the BCC method. Right next to the 'To' field in your Gmail, you'll find two other options: 'CC' and 'BCC'. ...
- Fill in the BCC fields. ...
- Hit the “Send” button.
Add your subject line and email text. Add the primary recipient's email address of your email in the To line. If you have multiple addresses in your distribution list, use a comma to separate multiple addresses from one another. Once you've done that, click on the BCC button at the right end of the To address box.
How do I mass mail merge emails? ›
How to send mass email in Outlook
- Step 1: Draft your message in Microsoft Word. ...
- Step 2: Start Mail Merge. ...
- Step 3: Select your email recipients. ...
- Step 4: Personalize your message. ...
- Step 5: Finish & Merge. ...
- Create professional-looking emails that match your brand. ...
- Save time on list management. ...
- Avoid email blacklists.
On the Mailings tab, choose Select Recipients and select Type a New List. In the New Address List dialog box type recipient information in each column as appropriate. For more info on using the dialog box, see Edit Data Source. For each new record, select Add New.
How do I send bulk emails to multiple recipients in Outlook? ›
How To Send Mass Email In Outlook
- Write Your Email Copy In Word. The first step to sending your email messages to your recipients through Outlook is to create a new Word document and add your copy. ...
- Select The Mail Merge Option. ...
- Select Your Email Recipients. ...
- Click on Finish & Merge and Send Your Campaign.
Bcc, or “blind carbon copy” functions the same as “Cc”, with one difference: Bcc-ed addresses are hidden from all recipients. Both features are available in Gmail and Outlook.
How do I send a mass email without showing other recipients? ›
How to Send a Group Email Without Showing All Recipients in Gmail
- Step 1: Click “Compose”
- Step 2: Type in "Undisclosed recipients" in Email "To" field.
- Step 3: Select “BCC” in Gmail.
- Step 4: Insert recipients or Gmail group.
- Step 5: Create your message and send the same email to multiple recipients separately.
Outlook. When you open a new blank email in Outlook, click on the “Options” tab. From there, you'll want to select the Bcc field in the message header. This is your “blind carbon copy” option, meaning that your email recipients will not see other names on the list.
Doing a mail merge instead of using the Bcc method removes the 'reply-all' privacy risk entirely because instead of creating blind copies, each recipient gets their own individual email.
How many recipients can you send in one email? ›
Messages that counts toward user limits
| Limit type | Limit |
|---|
| Auto-forward mail filters Account filters that automatically forward messages | 40 |
| Recipients per message Addresses in the To:, Cc:, and Bcc: fields of a single message* | 2,000 total per message (maximum of 500 external recipients ) |
7 more rowsDisadvantages Of Mail Merge
Too much work setting everything up. Way too many errors to deal with. Can't automate follow-up emails. No spam control.
How do I mail merge multiple records on one page? ›
Use a Label Type Mail Merge, based on the Microsoft 1/2 Letter label. After attaching the data source, insert the required mergefields into the first label on the sheet, then use the Update Labels function and then Finish & Merge>Edit Individual Documents to execute the merge.
How do you send an email to multiple recipients so that when they receive it they will not know who else received it? ›
Bcc, or “blind carbon copy” functions the same as “Cc”, with one difference: Bcc-ed addresses are hidden from all recipients.
How many emails can be sent at once in Outlook mail merge? ›
For Microsoft 365 subscribers, you can send emails to a maximum of 5,000 recipients a day, and each message can be sent to a maximum of 500 recipients.
How do I send a letter to multiple recipients in Word? ›
In Microsoft Word, from the Mailings tab, click Start Mail Merge. Select Letters. Click Select Recipients from the Mailings tab. Select Use Existing List.
