Mail merge with a different attachment for each recipient
Mail merge personalises the message but not the attachment. If you need to send every client their own invoice, every manager their own figures, every rep their own list, standard mail merge leaves you stuck. Here is why, and three ways around it.
Prepare my emails now — free, no sign-up →Why mail merge cannot do it
In a mail merge, every field you insert — name, company, amount — is pulled from a column in your data source. The attachment is not a field. Word and Outlook treat it as part of the message, not as merge data, so all recipients get the same file, or nothing at all.
This is not a setting you have missed. It is a genuine gap in the feature, and it is why "mail merge with individual attachments" is one of the most repeated questions in Office forums.
The three ways around it
| Approach | What it involves | Worth it when |
|---|---|---|
| Split the data first | Break the spreadsheet into one file per recipient, then generate one draft per person with that file attached | Your data lives in a spreadsheet and each recipient needs their own slice of it |
| VBA macro | A script in Outlook that loops through rows and attaches a file matching each one | You are comfortable with code and the process repeats unchanged for years |
| Paid add-in | A commercial mail merge tool with attachment support | You send high volumes regularly and want scheduling and tracking too |
The no-code way, step by step
If your data is already in Excel, the fastest route needs no macro and nothing installed. Split & Send runs entirely in your browser.
- Keep everything in one file. All rows in a single sheet, with one column saying who each row belongs to — Client, Region, Salesperson.
- Split by that column. You get one Excel file per recipient, formatting intact.
- Assign the email addresses. Map each value to the right person and write the message once — it is reused for everyone.
- Open the drafts and send. One .eml per recipient, each with its own attachment already in place.
🔒 Privacy: the file is processed locally in your browser and never uploaded, so it is safe for invoices, payroll and client data.
What you stay in control of
Nothing is sent automatically. The drafts land in your mail client and you send them yourself, which means you can spot a wrong address or a wrong figure before it reaches a client — the failure mode that makes people wary of mail merge in the first place.
Try it with your spreadsheet →Frequently asked questions
Can mail merge send a different attachment to each recipient?
Not on its own. Word and Outlook mail merge personalise the text of the message, but the attachment is not a merge field, so every recipient receives the same file or none at all. Sending individual attachments requires either VBA, a paid add-in, or a tool that prepares one draft per recipient.
How do I send personalised emails with individual attachments without VBA?
Split your data by the column that identifies each recipient, then generate one email draft per group with that group's file attached. Split & Send does this in the browser for free, with no macros and nothing to install.
Can I separate mail merged letters and send them individually?
Yes. Instead of producing one merged document, split the source data by recipient first. You then get a separate file per person and a separate draft per person, each with the right attachment.
Does it work with Outlook?
Yes. Each draft is a standard .eml file that opens in Outlook, Thunderbird and most mail clients as an editable draft, with recipient, subject, body and attachment already filled in.
Are the emails sent automatically?
No. The drafts are prepared but nothing is sent for you. You open each one, check it and send it yourself.
Is my data uploaded anywhere?
No. The spreadsheet is processed locally in your browser and never leaves your computer, which makes it safe for confidential client or payroll data.