How to Send Bulk Email from Outlook Using Excel (3 Ways)

We will use the sample list below and try to send emails to these email ids with the help of Excel, Outlook, Word, and Power Automate using 3 different methods.

We have used Microsoft Office 365 version here, you can use any other version that works best for you.

Method 1 – Sending Bulk Email with File Attachment Using Excel and Outlook

Steps:
➤ Click on the dropdown symbol in the top right corner of the Excel file.

➤ Check the Email option. This will put the Email icon in the quick access bar.

➤ Click on the Email icon.

➤ The Outlook window will open up with the Excel file automatically attached to the email.
➤ Type in the recipients’ email IDs separated by semicolons (;) in the To box.

➤ Click on Send and then the file attachment will be sent to each recipient.

Method 2 – Using Excel and Word to Send Bulk Email from Outlook

Here’s how to send an email to multiple recipients without manually entering their email IDs. For this method requires Microsoft Word, Excel, and Outlook.

In the example below, we have inserted the column header names in the first row, and the sheet name is Word.

Step 1: Creating Recipient List from Excel File

➤ Open a blank Word document.

➤ Go to the Mailings Tab >> Start Mail Merge Dropdown >> E-mail Messages Option.

➤ Go to the Mailings Tab >> Select Recipients Dropdown >> Use an Existing List Option.

➤ Select the specific Excel file (in this example, Sending Bulk Mail.xlsx) in the File Explorer window and click Open.

➤ The Select Table wizard will open up.
➤ Select the sheet name in which you have the list of email ids.
➤ Check the option First row of data contains column headers and click OK.

Step 2: Creating Structure of Email

➤ Type in the email content.

➤ Keep your cursor after Dear where you want the name, then go to the Mailings Tab >> Insert Merge Field Dropdown >> First_Name (Field name containing the first names of the recipients).

The selected field name will appear after Dear.

➤ To see the result of this inserted field, go to the Mailings Tab >> Preview Results Group >> Preview Results Option.

You will see the first name (for example, Sara) from the list appear after Dear.

➤ For sending this email go to the Mailings Tab >> Finish & Merge Group >> Send Email Messages Option.

➤ The Merge to E-mail wizard will pop up.
➤ Click on the dropdown symbol in the To box you will get various fields for different columns of your worksheet. Select the Email_Id field containing the email ids of the recipients.

➤ Click OK.

Method 3 – Sending Bulk Email from Outlook Using Excel and Power Automate

For this method, you will need Excel, OneDrive, Outlook, and Power .

In our sample file, we have converted the data range into a table. Go to the Table Design tab to see the name of the table, which is Table1. You will need to name (example, Sending Bulk Mail.xlsx ) and save the Excel file to OneDrive.

Step 1: Creating a Flow

➤ Go to your Microsoft Office 365 account and from various applications select Power Automate.

➤ Select the Create option from the left side and then the Instant cloud flow option from the right side.

➤ Select the Manually trigger a flow option and then press Create.

Step 2: Adding First Step for Excel File

➤ Click on +New step.

➤ Search for Excel in the search bar.
➤ Select the location where you have saved your file (in this example, Excel Online (Onedrive) option).

➤ Select the List rows present in a table option.

➤ Click on the Folder symbol beside the File box.

➤ Select the folder name which contains the required Excel file (here, we are selecting the EXCEL folder).

➤ Select the required file (example, Sending Bulk Mail.xlsx)

➤ In the Table box, select the table name (Table1) of the file which contains the email addresses.

Step 3: Adding Second Step for Outlook

➤ Click on +New step to add a step to send the emails through Outlook.

➤ Search for Outlook in the search bar.
➤ Select the Outlook.com option.

➤ Search for email and select the Send an email (V2) option.

➤ To select the email addresses, click on the Add dynamic content option below the To box.

➤ Select Email Id (the name of the column containing email ids) under the List rows present in a table flow.

➤ The word value will appear in a box, which means that this output has been selected from the previous step.
➤ Select the Send an email (V2) flow to see the details of this flow.

➤ Write the email content.

➤ To address each recipient of the email, select the First Name (the column name containing the first names) option from the dynamic content keeping the cursor after Dear.