How to Send Emails to Multiple People Individually: 3 Step-by-Step Methods

Outlook

1. 1
   Create a spreadsheet with recipient information. While there are other ways to format recipients for a mail merge , using a spreadsheet is the quickest and the easiest. If you already have a spreadsheet with recipient info, you can skip this step. ^[1]

   • Your spreadsheet should contain at least a column for the recipient's first name, last name, and email address. Make sure to include columns for any additional relevant info, as you should have a column for each placeholder you put in your email message.
   • Ensure you add column headers describing what each column of data is.
2. 2
   Draft your email. Before sending, draft your email. Mail merge allows you to customize an email message to each recipient so you can include their name and other relevant information. This leads to a more professional-looking email that is more likely to entice recipients.

   • If you're drafting in Word, create a new document and select Mailings > Start Mail Merge > E-mail Messages. Leave placeholders for the variables you are going to replace with merge fields later.
3. 3
   Select Select Recipients in the Mailings tab. If you're not using Word, this option may be in a different location. In the dropdown, select Use an Existing List…
4. 4
   Choose the data spreadsheet you created. Check the "First row of data contains column headers" box at the bottom of this dialog box.
5. 5
   Highlight each placeholder and replace them. Click the Insert Merge Field button once you've highlighted a placeholder, and select which merge field you want to use from your data sheet. For example, if you've got a placeholder in your email draft for a first name, highlight it and replace it with the merge field correlating to first names.
6. 6
   Preview your results. Click the arrows next to Preview Results to make sure the email looks correct and there are no issues with the merge fields.
7. 7
   Select Finish & Merge > Send Email Messages… . This will begin the process of sending your emails. Note that you should have the desktop version of Outlook installed and set up to use this method.
8. 8
   Change the "To:" dropdown to the email column header from your data sheet. This will ensure your emails get sent to your recipients' email addresses.
9. 9
   Enter a subject line. This will be the subject line present on all of the email messages.
10. 10
    Select how many recipients you want to send your email to. If you want to send it to everyone on the data sheet, select All . Otherwise, you can specify which rows in your data sheet you want to send the email to (i.e., if you only want to send the email to recipients on rows 1 through 10, you'd put those numbers next to "From:" and "To:").
11. 11
    Press OK . The emails will move to your Outlook outbox and are ready to send.
12. 12
    Open Outlook and click on your Outbox. All of your personalized mail merge messages will be in this folder.
13. 13
    Click Send/Receive All Folders . This will send all of your mail merge emails to their recipients.
Advertisement

Gmail

1. 1
   Create a spreadsheet with recipient information. While there are other ways to format recipients for a mail merge, using a spreadsheet is the quickest and the easiest. You can skip this step if you already have a spreadsheet with recipient info. ^[2]

   • Your spreadsheet should contain at least a column for the recipient's first name, last name, and email address. Make sure to include columns for any additional relevant info, as you should have a column for each placeholder you put in your email message.
   • Ensure you add column headers describing what each column of data is.
2. 2
   Draft your email. Before sending, draft your email. Mail merge allows you to customize an email message to each recipient so you can include their name and other relevant information. This leads to a more professional-looking email that is more likely to entice recipients.

   • Use placeholders for mail merge data, such as first and last names or any other relevant information.
   • This step is optional, as you can draft your email directly in Gmail as well.
3. 3
   Open Gmail and compose a new email. You can also work out of an existing draft if you have one.
4. 4
   Click the mail merge button on the "To:" line. This button looks like two people with a plus sign next to them.
5. 5
   Turn on mail merge and select Add from a spreadsheet . Select your spreadsheet in the popup and click Link .
6. 6
   Use the dropdowns to select the email address and first name columns. This will automatically fill your email with the correct recipients. You can add a last name as well, but it's optional.
7. 7
   Click Finish . Your spreadsheet will be added to the recipient line in your email.
8. 8
   Paste your draft into the email body. You can copy and paste this from your word processing document, but if you opted not to create a draft, you can type your email directly into the body field.
9. 9
   Add merge fields by typing @ . You can select a merge tag from the dropdown by pressing Enter . These tags are determined by the column headers on your spreadsheet.

   • If you are creating your email from a draft you wrote with placeholders, replace the placeholders with the merge tags.
10. 10
    Send the email. Once you've finished drafting the email and have the merge fields set, you can send it to your recipients. In your Sent folder, you can view your mail merge emails with the "Sent with mail merge" filter.
Advertisement