Attachment Issues

How to Send Personalized Bulk Emails with PDF Attachments in Excel and Word

Tauseeq Magsi Oct 9, 2026 868 views

Question details

The user needs to perform a mail merge to send customized bulk emails, where each recipient receives a personalized letter-style message and an individual PDF service agreement generated from Word and Excel data.

How to Send Personalized Bulk Emails with PDF Attachments in Excel and Word

Product: Word, Excel
Device & OS: not provided
Scenario: Automating the process of sending personalized bulk emails with specific PDF attachments to multiple customers.
Observed behavior: Standard mail merge does not natively support attaching individual PDF files to separate emails, requiring alternative methods or automation.

Before you start

Ensure your Excel spreadsheet is properly formatted with headers and valid recipient email addresses. Additionally, verify that your default desktop email client, such as Outlook, is configured and running on your computer.

Solution 1Recommended

Use Word Mail Merge with a VBA Macro

Because standard Word Mail Merge does not support individual attachments natively, utilizing a VBA macro allows you to automate generating and attaching PDFs.

This method requires Outlook to be set as your default email client. The VBA macro will iterate through your Excel mailing list, convert the merged documents to PDFs, and attach them to individual emails.

Prepare the Excel Data

Open your Excel data source and ensure you have a column with the recipients' email addresses and any specific data fields required for the PDF agreement.

Set Up the Word Document

Open Word, go to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List' to link your Excel file. Insert the necessary merge fields into your document.

Insert the VBA Macro

Press 'Alt + F11' in Word to open the VBA editor. Go to 'Insert' > 'Module' and paste a customized Mail Merge to PDF macro script (commonly available on official Office support forums).

Run the Macro

Execute the macro from the VBA editor. It will automatically merge the data, generate individual PDF files, and send them via Outlook to the addresses specified in your Excel list.

Macro Security: You may need to adjust your Macro Security settings in the Word Trust Center to allow the execution of VBA scripts.

Solution 2

Use a Third-Party Mail Merge Add-in

If you are unfamiliar with VBA scripting, using a dedicated Mail Merge add-in is a simpler way to attach personalized PDFs.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

While complex VBA macros for email attachments often require specific Microsoft Office configurations, WPS Office provides a lightweight, free alternative for all your standard word processing, spreadsheet, and mail merge needs.

1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
2. Open Your Files: Launch WPS Office and open your existing .docx and .xlsx files directly without any conversion issues.
3. Use Built-in Mail Merge: Navigate to the 'References' tab in WPS Writer to easily connect your Excel data source and start merging documents.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Includes a built-in Mail Merge feature for quickly generating personalized letters and documents.Built-in PDF toolkit allows you to easily convert Word and Excel files to PDF format.Free, lightweight, and features a familiar tabbed user interface for easy migration.

Frequently Asked Questions

Can standard Word Mail Merge send emails with attachments natively?

No, the built-in Mail Merge feature only sends the merged document as the body of the email or as a single uniform attachment. It cannot natively attach different, individual PDF files to each email without the use of VBA macros or external add-ins.

How do I prepare my Excel list for sending specific PDF attachments?

If you are using a macro or an add-in, you should include a dedicated column in your Excel spreadsheet containing the exact local file path (e.g., C:\Documents\agreements\client1.pdf) for each recipient's specific PDF file.

Why are my mail merge emails sitting in the Outlook Outbox?

This typically happens if Outlook is offline, disconnected, or if another process is holding the queue. Open Outlook, check your connection status at the bottom right, and click 'Send/Receive' to push the emails through to your mail server.

Outlook & Email Problems