- © 2026 Mailsoftly Inc. The name "Mailsoftly" and the Mailsoftly logo are registered trademarks of Mailsoftly Inc.
by Isabella Torres · Last updated: 2026-09-26A standard mail merge in Word, Outlook or Gmail cannot attach files. To mail merge with attachments, you need either an add-on that reads a file path or Drive link from a column in your spreadsheet, or an email platform that builds the attachment for each person. If every recipient needs their own PDF (a statement, certificate or invoice with their details on it), the fastest route is a tool that generates a personalized PDF per recipient from one template at send time, so there are no files to prepare at all.
This guide walks through every option, from free workarounds to add-ons, and shows where each one breaks down.
New here? Start with our primer on Email Marketing Fundamentals for the fundamentals, then come back to this guide.
Quick context: Mailsoftly can build a personalized PDF for every recipient and send it as a secure link with a per-person access code. Create a free account, no credit card, and ask us to switch secure documents on for it.
Send documents securely with Mailsoftly →
Key Takeaways
Design the certificate once as a template with merge fields, choose it as the campaign’s personalized attachment, and Mailsoftly builds one PDF per person at send time and attaches it to that person’s own email. Pick Letter or A4, portrait or landscape, preview every attendee’s certificate, and send. The video below shows the whole flow with a workshop certificate of completion.
0:00 Mail merge certificates. Here’s how to send every attendee their own certificate, with their name on it, attached to a personal email.
0:08 Why not a Word mail merge? The usual way is a Word mail merge, which makes one big document. Then you split it, save each certificate, and attach them one by one, hoping nobody gets the wrong name. Here’s the same job, done in one campaign.
0:23 How do I attach a certificate to each email? Start with your email, a congratulations note for the whole workshop. Under Attachments, choose a template for the personalized attachment. Search for certificate, and pick it. The certificate has merge fields for the name and the workshop track. The file name uses them too, so every PDF is named after its person.
0:45 How do I set the page and preview each certificate? Now the page. Letter is set for a US account. Switch to landscape, and the design fills the page. Then preview the real PDFs, built for each person. Here’s Olivia’s certificate, with Olivia’s name and track filled in. Hit next to go to the next attendee. There’s Marcus, on the Web Design track.
1:07 How do I send them? Delivery stays on Attach the PDF, so each certificate travels inside its own email. Now review each person’s copy. Marcus’s email says Hi Marcus. Send it, check the list it’s going to in the next window, and confirm. Every attendee gets a personal email, with their own certificate attached. Personal certificates for every attendee, sent in one go. Learn more at mailsoftly.com.
Mail merge cannot include attachments because it was built to personalize text, not to move files. Word takes your recipient list, fills merge fields such as first name and account number into the message, and hands each finished email to Outlook. The attachment step simply is not part of that flow, which is why “mail merge with attachments” is one of the most searched mail merge problems.
There are two very different situations hiding behind that search, and they need very different tools. Sending the same file to everyone is easy. Sending a different file to each person is the hard case, and it is the one this guide focuses on.
Need each recipient to get their own document? Mailsoftly builds one PDF per person from a single template.Send documents securely with Mailsoftly →
Word’s Mailings tab has no attachment setting, so people reach for one of three add-on routes. Each one works, and each one expects you to already own a correctly named file per person before the merge starts.
| Method | How it works | Trade offs |
|---|---|---|
| Outlook add-ins | A paid add-in adds an attachment column to the merge; each row points to a file on your computer. | Windows only in most cases; licence per user; files must exist before you merge. |
| VBA macro | A script loops through your list, creates each email and attaches the file named in a column. | Free, but fragile; security settings often block macros; hard to hand over. |
| Power Automate | A flow reads an Excel table and sends one email per row with a file from OneDrive or SharePoint. | Needs a Microsoft 365 plan with Power Automate; slower to build than it looks. |
All three share the same prerequisite: you must already have one correctly named file per person, stored where the tool can find it. If you are picking an email stack to build on rather than patch, our overview of what to look for in email marketing software covers the trade-offs beyond attachments.
Gmail has no native mail merge with attachments, but Google Sheets add-ons fill the gap. GMass, Mailmeteor and YAMM (Yet Another Mail Merge) can all read a column of Google Drive file links or names and attach a different file to each email. Check each add-on’s current plan limits before you commit.
When the attachment is different for every person, the smartest move is to generate it, not collect it. Every option above assumes you already have a folder of personalized files. In most real cases, you do not. You have a spreadsheet of names and numbers, and a document that should be filled in for each person.
That is exactly the job a platform can do for you. Instead of exporting 400 PDFs and matching them to 400 rows, you design the document once, with merge fields where the personal details go, and the platform renders one PDF per recipient at send time. There are no files to name, upload or match, which is where the manual routes usually go wrong.
Mailsoftly’s Attachments card on a campaign has two parts: Shared files, for a file every recipient gets, and Personalized attachment, for a PDF built for each person. Here is the full flow.
Personalized documents also work inside automations, so a certificate can go out the moment someone completes a course, or a welcome pack the moment someone joins. Attachments and personalized documents are switched on per account by our team, so ask us and we will turn them on for yours.
Detailed guides walk through each stage: create and preview personalized PDFs, then run a mail merge for emails and documents, and finally attach files to a campaign.
The routes diverge most on two points: whether you have to prepare the files yourself, and whether you can protect anything personal. Mailsoftly pricing is transparent and starts free (as of 2026-09-07); the free plan covers 500 contacts and 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account. The Starter plan is $15 a month (billed yearly) for 1,000 contacts and 10,000 emails, and lets you send from your own domain.
| Word + Outlook add-in | Gmail + Sheets add-on | Mailsoftly | |
|---|---|---|---|
| Same file for everyone | Yes | Yes | Yes (Shared files) |
| Different file per person | Yes, from files you prepare | Yes, from Drive files you prepare | Yes, generated from one template |
| Preview each person’s file | No | No | Yes |
| Secure link instead of attachment | No | No | Yes, with per-person access code |
| Track who opened the document | No | Email opens only | Per recipient, per document |
| Daily sending limit | Your mailbox limits | Gmail limits | Your plan’s limits, not your mailbox’s |
Send a link instead of an attachment whenever the file is personal. Attachments are fine for brochures and agendas. For a payslip, statement or record, a secure link is safer: the file never sits in the inbox, the link can expire, and you can turn it off if you sent it to the wrong address.
With Mailsoftly’s Secure link, the recipient confirms a per-recipient access code in the format XXXX-XXXX, and optionally a detail already on file (up to two checks), before the document opens. The code never rides in the email that carries the link, so intercepting the message alone is not enough. If the recipient needs to keep the file, you can also lock the downloaded PDF with that same access code (AES-256), so it stays protected on their device. Our guide to sending a password protected PDF by email covers the manual and bulk options side by side.
For the broader picture on this topic, see our complete Email Marketing Fundamentals guide, which covers strategy, fundamentals, and advanced playbooks.
Yes. Connect your Microsoft 365 or Gmail mailbox to Mailsoftly and set it as the campaign’s From address. Each person’s PDF is built from their details at send time and attached to an email that goes out through your own mailbox, so it appears in your Sent folder like any email you write. The same personalized attachment works when you send through Mailsoftly instead. Personalized attachments are switched on per account; ask the team to turn them on for yours.
Not with the built-in Word and Outlook mail merge. You need an Outlook add-in, a VBA macro, or a Power Automate flow, and each one expects a ready-made file per recipient before the merge runs.
Put the file path or Drive link for each person in a spreadsheet column and use an add-on that reads it, or use a platform like Mailsoftly that generates a personalized PDF for every recipient from one template at send time.
Yes, with a Google Sheets add-on such as GMass, Mailmeteor or YAMM. Gmail’s daily sending limits still apply to every merge, so plan around roughly 500 messages on a personal account and 2,000 on Workspace.
In Word you can merge to individual documents, save each as PDF, and then attach them one by one or through an add-on. Mailsoftly skips the export step: it turns a saved template into one PDF per recipient and emails each person their own copy.
It works, but an attachment stays in the inbox and opens for anyone the email reaches. For payslips, statements or records, send a secure link that asks for a per-person access code instead, and share that code in a separate message rather than the email carrying the link.
Send every recipient their own document, securelySend documents securely with Mailsoftly →
500 contacts, 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account. Free hands-on migration. No credit card.
Ready to boost your email marketing?
Send beautiful, targeted emails that convert. Free plan available, paid plans from $15 a month.
Try Mailsoftly FreeNo credit card required