Attachment Issues

How to Send One Email with Multiple Attachments Using Mail Merge

Steve K Sep 28, 2026 869 views

Question details

The user needs to send a single email containing multiple file attachments (such as several invoices) to individual recipients using the Mail Merge feature, rather than sending a separate email for every single file.

How to Send One Email with Multiple Attachments Using Mail Merge

Product: Mail Merge
Device & OS: not provided
Scenario: A many-to-one mail merge where multiple personalized documents need to be grouped and emailed to a single customer.
Observed behavior: Standard mail merge tools default to sending a separate email for each record or only attaching the first file, failing to group multiple attachments for a single recipient.

Before you start

Ensure all the files you intend to attach are organized in a single folder, and verify that your recipient data source (like an Excel spreadsheet) is properly updated and cleaned.

Solution 1Recommended

Use Cloud Storage Links Instead of Direct Attachments

Since native mail merge struggles with grouping multiple attachments, uploading files to a cloud service and merging the shared links is the easiest no-code workaround.

This method avoids email file size limits and bypasses the many-to-one mail merge limitation entirely. By giving recipients a single link to a folder or a combined document, you simplify the delivery process.

Upload files to a cloud service

Create a dedicated folder for each recipient in OneDrive, Google Drive, or WPS Cloud, and upload their specific files (e.g., invoices) into it.

Generate shareable links

Right-click each customer's folder in your cloud drive and select 'Share' to generate a view-only link.

Update your data source

Open your Excel contact list and create a new column named 'Attachment Link'. Paste the corresponding shareable link for each customer into this column.

Insert the link into your Mail Merge

In your word processor, draft your email and use the 'Insert Merge Field' button to add the 'Attachment Link' field into the body of the email before finishing the merge.

Use Cloud Storage Links Instead of Direct Attachments

Delivery Benefit: Sending links instead of physical files significantly reduces the chance of your emails being flagged as spam or bouncing due to attachment size restrictions.

Solution 2

Combine Files into a Single PDF Archive

Merge multiple documents meant for one recipient into a single file before performing a standard mail merge.

Solution 3

Automate with a Custom VBA Script

Use Visual Basic for Applications (VBA) to programmatically group attachments and send them via Outlook.

Combine Documents for Mail Merge

Easily Merge Multiple Files into One PDF with WPS Office

Bypass mail merge limitations by combining your recipient's multiple attachments into a single, clean PDF. WPS Office includes powerful built-in PDF tools alongside its robust Writer and Spreadsheet applications, allowing you to seamlessly manage documents and run mail merges.

1. Open WPS PDF Tools: Launch WPS Office and navigate to the 'PDF' tab on the main dashboard.
2. Select Merge PDF: Click on 'Merge PDF' and add the multiple documents or invoices intended for your recipient.
3. Save the Combined File: Arrange the pages if necessary, then click 'Merge' and save the new single PDF file to your computer.
4. Execute Mail Merge: Open WPS Writer, navigate to the 'References' tab, select 'Mail Merge', and attach the newly created single PDF to send to your customer.

Built-in PDF toolkit to instantly merge multiple Word, Excel, or image files.Fully compatible with Microsoft Office formats (.docx, .xlsx) and mail merge workflows.Send professional, single-attachment emails effortlessly.Free, lightweight, and features an intuitive tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can standard Word Mail Merge send multiple attachments natively?

No, standard mail merge features in most word processors default to sending one document or generating one email per data record. It does not natively group multiple different files into a single email.

Are there third-party add-ins that handle Many-to-One mail merges?

Yes, there are specialized add-ins available for email clients like Outlook (e.g., MAPILab or Doug Robbins' Merge Tools) that specifically enable many-to-one mail merging and multiple attachments.

Can I use Power Automate to send multiple attachments?

Yes, Microsoft Power Automate can be configured to pull data from a SharePoint list or Excel table, group the items by the recipient's email address, and attach all related files to a single 'Send an email' action.

How do I avoid email size limits when sending several files?

The best way to avoid size limits is to upload your files to a cloud storage provider (such as Google Drive, OneDrive, or Dropbox). You can then include the shared folder link in your mail merge document instead of attaching heavy files directly.

Outlook & Email Problems