Send & Receive Issues

How to Send an Excel Recipient List via Outlook BCC in Microsoft 365

Camila Milosovich Oct 22, 2026 868 views

Question details

The user needs to send an email to hundreds of recipients by placing an Excel contact list into the Outlook BCC field, but Excel for the web does not natively support this.

How to Send an Excel Recipient List via Outlook BCC in Microsoft 365

Product: Microsoft Excel for the web
Device & OS: not provided
Scenario: Attempting to trigger or automate a bulk email to a large list of BCC recipients directly from an online Excel worksheet using Microsoft 365 tools.
Observed behavior: Excel for the web lacks a worksheet button or cell formula to open a new Outlook message with hundreds of BCC recipients, and Office Scripts restrict launching email clients.

Before you start

Ensure you have access to Microsoft Power Apps, the Office 365 Outlook connector, and check your organization's sending limits to ensure you can email up to 500 recipients at once.

Solution 1Recommended

Use Power Apps with the Office 365 Outlook Connector

Since Excel for the web cannot trigger emails directly, building a simple Power App linked to your Excel data is the most reliable workaround for sending bulk BCC emails.

Power Apps allows you to bypass the email restrictions of Excel for the web and Office Scripts. By combining your online Excel table with the Office 365 Outlook connector, you can dynamically pull your contact list and push it into the BCC field of an email.

Store your Excel data

Save your Excel workbook containing the recipient list in a cloud location like OneDrive for Business or SharePoint, ensuring the data is formatted as an Excel Table.

Create a Power App

Open Microsoft Power Apps, create a new Canvas app, and add your Excel table as a data source.

Add the Outlook Connector

In the data sources panel, search for and add the 'Office 365 Outlook' connector to your app.

Configure the BCC field

Insert a recipient control or use a function like Concat() to combine the email addresses from your Excel table into a single string separated by semicolons.

Trigger the email

Insert a Button into your app. Set its OnSelect property to call Office365Outlook.SendEmailV2. Map your concatenated email string to the BCC property and fill in your desired Subject and Body.

Use Power Apps with the Office 365 Outlook Connector

Recipient Limits: Review Microsoft 365 organizational email policies before sending. Outlook typically restricts emails to approximately 500 recipients per message. If your list is larger, you may need to batch your sends.

Free Microsoft Office alternative

Need a simpler way to manage spreadsheets? Try WPS Office

If setting up complex Microsoft 365 web automations like Power Apps is too tedious, consider switching to WPS Office. It provides a lightweight, highly compatible, and completely free desktop experience for seamlessly managing your large Excel recipient lists and daily data tasks.

1. Download and Install: Get the free WPS Office installer from the official website and complete the setup process.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Microsoft Excel recipient list without losing any formatting.
3. Manage Data Locally: Use WPS Office's built-in tools to manage, filter, and export your contact lists locally without complex web environment restrictions.

100% compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight desktop application that avoids browser-based restrictionsFamiliar user interface that requires zero learning curveBuilt-in robust tools for data filtering, sorting, and management

Frequently Asked Questions

Why can't I send an email directly from Excel for the web using a macro?

Excel for the web does not support VBA macros or COM add-ins. While it does support Office Scripts, these scripts have strict security restrictions that prevent them from directly launching email clients or sending emails without integrating external tools.

What is the maximum number of BCC recipients I can send to via Outlook in Microsoft 365?

Microsoft 365 typically limits users to sending a message to a maximum of 500 recipients at one time. If your Excel list exceeds this limit, you must divide your recipients into smaller batches to avoid delivery failures or being flagged as spam.

Can I use Power Automate instead of Power Apps to send the email?

Yes. You can create a Power Automate flow using the 'For a selected row' trigger in Excel for the web. The flow can read the recipient list and use the Office 365 Outlook connector to automatically send an email, providing a background automation alternative to building a Power App.

Outlook & Email Problems