Others

How to Send Mail Merge Attachments in Outlook for the Web with Power Automate

Algirdas Jasaitis Oct 9, 2026 871 views

Question details

The user needs a method to send mail merge emails that include multiple OneDrive attachments, CC/BCC recipients, and inserted images via Outlook for the Web.

Product: Outlook for the Web
Device & OS: not provided
Scenario: Attempting to perform an advanced mail merge with attachments and specific recipient routing directly from the web browser.
Observed behavior: Outlook for the web lacks a built-in mail merge feature that supports multiple attachments, CC/BCC capabilities, and inline images.

Before you start

Ensure you have an active Microsoft 365 subscription with access to Excel Online, Power Automate, and OneDrive or SharePoint to host your attachment files.

Solution 1Recommended

Use Excel Online and Power Automate

Create an automated workflow linking an Excel Online workbook to Outlook to process and send customized emails with attachments.

Since Outlook for the Web does not natively support advanced mail merges with attachments, Microsoft Power Automate serves as the perfect bridge. By storing your data in Excel Online, you can automate the process of extracting recipient details and sending customized emails.

Set up your Excel workbook

Open Excel Online and create a formatted Table containing columns for Recipient Email, CC, BCC, Message Body, and Attachment Links.

Store attachments in the cloud

Upload the files you intend to attach to OneDrive or SharePoint. Generate direct sharing links for these files and paste them into the corresponding rows in your Excel table.

Create a Power Automate flow

Log into Power Automate and create a new Instant Cloud Flow. Select the trigger 'For a selected row' (Excel Online) or use a manual trigger to initiate the sequence.

Configure the email action

Add a new action called 'Send an email (V2)' under the Office 365 Outlook connector. Map the dynamic content from your Excel table to the To, CC, BCC, and Attachments fields.

Run your automated flow

Navigate to the Automate tab within your Excel Online workbook, select your newly created flow, and run it to dispatch the customized emails.

Add a Condition Column: To prevent sending emails accidentally to the entire list, add a condition column (e.g., 'Ready to Send? = Yes') in your Excel table, and add a Condition block in Power Automate before the email action.

Solution 2

Submit Feature Feedback to Microsoft

Request built-in support for advanced mail merges in Outlook for the Web directly from the development team.

Free Microsoft Office alternative

Looking for a Simpler Desktop Office Suite? Try WPS Office

If complex web automations like Power Automate feel overwhelming, consider switching to WPS Office. It provides a robust, desktop-based experience with traditional Mail Merge tools built right into WPS Writer, removing the steep learning curve of cloud automation.

1. Download the Installer: Visit the official WPS Office website and download the free version suited for your operating system.
2. Install WPS Office: Run the downloaded installation file and follow the quick on-screen prompts to set up the software.
3. Start Creating: Open WPS Writer or WPS Spreadsheet to immediately start editing your documents with full Microsoft format compatibility.

Free and lightweight office suite for Windows, Mac, and Linux systems.Fully compatible with Microsoft Office formats including DOCX, XLSX, and PPTX.Built-in, easy-to-use mail merge functionality within WPS Writer.Familiar user interface requires no retraining for Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Does Word for the Web support mail merge with attachments?

No, currently there is no built-in mail merge feature in Word for the Web or Outlook for the Web that supports attaching files, adding CC/BCC recipients, or inserting custom images.

Where should I save my attachments when using Power Automate?

You should store your attachment files in a cloud location accessible to Microsoft 365, such as OneDrive or SharePoint. You can then copy the file paths or sharing links into your Excel Online tracking sheet.

How do I ensure Power Automate only sends emails to specific rows in Excel?

You can add a dedicated column in your Excel table (for example, 'Status'). Inside your Power Automate flow, insert a 'Condition' action that checks if the Status column equals a specific value (like 'Approved') before proceeding to the 'Send an email' action.

Office Quick Solutions