Automatically send emails from an Excel list using Power Automate

3/17/2026

In office work, many people need to send emails to dozens or even hundreds of customers every day. Sending emails manually one by one takes a lot of time and can easily lead to mistakes such as sending the wrong content or missing recipients.

An effective solution is to automatically send emails from an Excel list using Power Automate. This Microsoft tool allows you to create automated workflows, helping you send bulk emails quickly and accurately.

This article explains how this solution works and how to apply it in your daily work.

What is Power Automate?

Power Automate is a tool within the Microsoft Power Platform ecosystem. It enables users to create workflows (automated processes) that connect multiple applications.

For example, Power Automate can:

• Automatically send emails
• Automatically save email attachments
• Automatically input data
• Automatically send notifications via Microsoft Teams

Thanks to this, repetitive office tasks can be automated efficiently.

Real-World Example

Imagine you have a customer list in Excel like this:

Name	Email	Content
Nguyen An	an@email.com	New program announcement
Tran Binh	binh@email.com	New program announcement
Le Cuong	cuong@email.com	New program announcement

If you send emails manually, you would need to:

1. Open Outlook
2. Copy each email address
3. Enter the content
4. Send emails one by one

If the list has 100 people, this process will take a significant amount of time.

With Power Automate, the system can:

1. Read data from Excel
2. Extract each email address
3. Automatically send emails

The entire process runs automatically in just a few minutes.

How to Automatically Send Emails from Excel Using Power Automate

The basic workflow typically includes the following steps:

Step 1: Prepare the Excel File

Your Excel file should include:

• Recipient list
• Email addresses
• Email content

The file should be stored on OneDrive or SharePoint so Power Automate can access it.

Step 2: Create a Flow in Power Automate

Go to Power Automate and create a new Cloud Flow.

The structure will look like this:

Trigger → Read Excel data → Send email

Step 3: Get Data from Excel Table

Power Automate can read data from an Excel Table.

Each row in the table corresponds to one email to be sent.

Step 4: Send Emails Automatically

After retrieving the data, Power Automate uses the Outlook connector to send emails.

Emails can include:

• Recipient name
• Personalized content
• Attachments

Example:

Dear {Name},

We would like to share information about our new program.

Power Automate will automatically replace {Name} with each recipient’s name from Excel.

Benefits of Automatically Sending Emails

Using Power Automate to send emails from Excel offers several advantages:

Save Time
Instead of sending emails individually, you only need to run the workflow once.

Reduce Errors
The system automatically pulls data, minimizing mistakes.

Send Bulk Emails
You can send emails to hundreds of recipients in a short time.

Personalize Content
Emails can automatically include customer names and other details.

Common Business Use Cases

Automatically sending emails from Excel is widely used for:

• Sending customer notifications
• Sending reports to managers
• Sharing promotional programs
• Sending internal announcements

This is one of the most popular use cases of Power Automate in businesses.

When Should You Use Power Automate Instead of Manual Emailing?

You should apply this solution when:

• The email list is large
• The content is similar
• Emails need to be sent regularly
• You want to reduce repetitive tasks

In many organizations, email automation can save several working hours each week.

Learn Power Automate to Automate More Tasks

Power Automate is a powerful tool that can automate many business processes, not just email sending. It can also:

• Automate data processing
• Automate data entry
• Build approval workflows
• Integrate multiple systems

If you want to learn how to build these workflows, you can explore Power Automate courses at Tanducits.

These courses help you:

• Understand how to build workflows
• Apply Power Automate in real work scenarios
• Automate various business processes

Conclusion

Automatically sending emails from an Excel list using Power Automate is a simple yet highly effective solution. With just one workflow setup, you can send emails to multiple recipients quickly and accurately.

This is also an important first step toward office automation, helping improve productivity and reduce manual work.

Training courses:

Microsoft Power Automate