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

If you are looking for ways to send a bulk of email from Outlook using Excel, then you are in the right place. Sometimes we need to send the same email to a huge number of recipients and to make this task easier this article will discuss different ways of doing this job. So, let’s start with our main article.

Download Workbook


3 Ways to Send Bulk Email from Outlook Using Excel

Here, we have a list of employees’ Ids, names, gender, age, and email id of a company. We will try to send emails to these email ids with the help of Excel, Outlook, Word, and Power Automate in the following 3 methods.

how to send bulk Email from outlook using Excel

We have used Microsoft Office 365 version here, you can use any other versions according to your convenience.


Method-1: Sending Email with File Attachment Using Excel and Outlook

Here, we will try to send emails to the following email ids by typing the ids manually in Outlook and we will attach this Excel file with the email.

how to send bulk Email from outlook using Excel

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

sending email with Excel file attachment

➤ Check the Email option among various options.

how to send bulk Email from outlook using Excel

After that, you will see the Email symbol in the quick access bar.
➤ Click on the Email sign.

sending email with Excel file attachment

Afterward, the Outlook window will open up where you can see the Excel file is automatically attached to this email.
➤ Type the recipient’s email ids serially separated by semicolons (;) in the To box.

sending email with Excel file attachment

To send this email to the recipient’s ids just click on the Send option and then the file attachment will be sent to each employee.

how to send bulk Email from outlook using Excel


Method-2: Send Bulk Email from Outlook Using Excel and Word

In this section, we will show the way to send an email to all of the recipients of the following email ids without typing their ids. For this method, we will need Microsoft Word with Excel and Outlook.
Here, we have inserted the column header names in the first row, and the sheet name is Word.

how to send bulk Email from outlook using Excel


Step-01: Creating Recipient List from Excel File

➤ Open a blank Word document.

sending email with Excel, Word and Outlook

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

sending email with Excel, Word and Outlook

Now, this document is ready to write an email but we have to do a few more steps before writing the email.
➤ Go to the Mailings Tab >> Select Recipients Dropdown >> Use an Existing List Option.

sending email with Excel, Word and Outlook
➤ Select the Excel file Sending Bulk Mail.xlsx (or your saved file with another name) in the File Explorer window and press Open.

how to send bulk Email from outlook using Excel

After that, 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 press OK.

sending email with Excel, Word and Outlook


Step-02: Creating Structure of Email

➤ Now, type the structure of the email.

sending email with Excel, Word and Outlook

As we want to address each employee’s name in their email after Dear we have to follow this step.
➤ Keep your cursor after Dear where you want the name, and then go to the Mailings Tab >> Insert Merge Field Dropdown >> First_Name (Field name containing the first names of the employees).

how to send bulk Email from outlook using Excel

Then, the selected field name will appear after Dear.

sending email with Excel, Word and Outlook

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

sending email with Excel, Word and Outlook

After that, you will have the first name, Sara, from the list of first names of the employees after Dear.

sending email with Excel, Word and Outlook

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

how to send bulk Email from outlook using Excel

Then the Merge to E-mail wizard will pop up.
➤ After clicking 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 employees.

sending email with Excel, Word and Outlook

In this way, we have placed the recipient’s email ids in the To box.
➤ To send this email to each employee you have to just press OK.

sending email with Excel, Word and Outlook


Method-3: Send Bulk Email from Outlook Using Excel and Power Automate

Excel, Onedrive, Outlook, and Power Automate will be required to send bulk emails in this section.
We have converted the data range into a table and by going to the Table Design tab we can see the name of the table which is Table1. And one more thing you have to save the Excel file, Sending Bulk Mail.xlsx (or any other filename), to Onedrive.

 Excel, Power Automate and Outlook


Step-01: Creating a Flow

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

 Excel, Power Automate and Outlook

In this way, we have opened our Power Automate with the help of which we will send our bulk emails.

 Excel, Power Automate and Outlook

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

 Excel, Power Automate and Outlook

After that, you will get different options to trigger this flow.
➤ For simplicity, you can select the Manually trigger a flow option and then press Create.

 Excel, Power Automate and Outlook


Step-02: Adding First Step for Excel File

After creating our flow and we have to just add some steps.
➤ Click on the New step.

 Excel, Power Automate and Outlook

After that, you have to include some operations in this step.
➤ Search for Excel in the search bar.
➤ Then we selected Excel Online (Onedrive) option because we have saved our file here.

 Excel, Power Automate and Outlook

After that, different types of Excel-related actions will appear.
➤ Select the List rows present in a table option.

 Excel, Power Automate and Outlook

➤ Click on the Folder symbol beside the File box.

 Excel, Power Automate and Outlook

After that, you will see the folder names remaining in your Onedrive.
➤ Select the folder name which contains the required Excel file (here, we are selecting the EXCEL folder).

 Excel, Power Automate and Outlook

Then, you will see all of the files in this folder and we are selecting the file Sending Bulk Mail.xlsx, you can select your saved file name.

 Excel, Power Automate and Outlook

After that, select the table name (Table1) of this file which contains our email addresses in the Table box.

 Excel, Power Automate and Outlook

We have completed the first step by inserting the file and its related table.


Step-03: Adding Second Step for Outlook

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

 Excel, Power Automate and Outlook

➤ Search for Outlook in the search bar.
➤ Then, we selected the Outlook.com option to send our emails.

 Excel, Power Automate and Outlook

➤ To select the definite action search for email and then select the Send an email (V2) option from various actions.

 Excel, Power Automate and Outlook

After that, the name of this step will be renamed Send an email (V2).
➤ To select the email addresses click on the Add dynamic content option below the To box.

 Excel, Power Automate and Outlook

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

 Excel, Power Automate and Outlook

Then, we can see a word value in a box which is saying that this output has been selected from the previous step.
➤ Now, select the Send an email (V2) flow to see the details of this flow.

 Excel, Power Automate and Outlook

➤ Write down the format of the email.

 Excel, Power Automate and Outlook

As we want to address each person to whom we want to send this email, so we have selected the First Name (the column name containing the first names) option from the dynamic content keeping the cursor after Dear.

 Excel, Power Automate and Outlook

➤ Select Apply to each to apply this step to all of the email ids.

 Excel, Power Automate and Outlook

We have completed all of the steps.
➤ Click on Save.

 Excel, Power Automate and Outlook

➤ After going back to the flows, just click on the Run option to send this email to all of the employees.

 Excel, Power Automate and Outlook


Conclusion

In this article, we tried to cover the ways to send bulk email from Outlook using Excel. Hope you will find it useful. For exploring more Excel-related articles you can visit our site Exceldemy.com.

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo