Not the job you came for? Tell me what you need

Email a different attachment to each recipient

Forty people, forty different PDFs, one action. Word, Outlook and Gmail can't do it by themselves — here's what can, what each one wants, and the one step that decides whether somebody gets a document about somebody else.

Why your mail merge won't do it

A plain mail merge personalises the message. Word's merge has no concept of attaching a file at all — its "send as attachment" option attaches the merged document itself, which is the same document logic for everybody. Gmail's multi-send has the same limit: one attachment, sent to the whole list.

So the usual first attempt sends everybody the same file, or sends everybody nothing. Neither of those fails loudly. That is a limit of the mail clients rather than of your spreadsheet, and the fix is an add-in.

Pick one, and it decides how much work this is

They differ on one thing that matters: whether the add-in pairs the files to the rows, or you do. Anything that asks you to paste a link per row is asking you to do the pairing by hand, forty times, every month — and a slip there is somebody else's document in somebody's inbox.

Add-in	Where	Who pairs them	What it wants
Yet Another Mail Merge	Gmail, from Google Sheets	It does	Files in a Drive folder. Import from Drive folder matches the file names to your rows and writes the attachment column for you. Its own docs ask for a unique ID in each file name — an account or client code is ideal.
Mail Merge for Gmail	Gmail, from Google Sheets	It does	The same idea under a different name: List Files in Google Drive Folder reads a folder, including sub-folders, and builds the list.
SecureMailMerge and similar	Outlook	It does	An Attachments column of plain file names, and the files in one folder on your computer. No Drive, no links, no cloud step at all. Several files for one person are separated by semicolons.
Mailmeteor	Gmail, from Google Sheets	You do	A Drive link pasted into the attachment column, row by row. Fine for a handful. This is the one that makes people conclude the whole approach is unworkable.

We have no arrangement with any of them and get nothing if you pick one. Check the current pricing and limits yourself — most of these have a free tier with a daily send cap, and your own mail provider has a separate one.

If you're in Outlook, there is no cloud step

1. Put the PDFs in one folder on your computer.
2. Open your spreadsheet. It needs a column of email addresses and a column of file names — 920-07 2026-08.pdf, not a path and not a link.
3. Start the add-in and point it at the folder. It reads the attachment column, finds those names in the folder, and asks you to confirm what it found.
4. Send a test to yourself first. Every one of these can do that.

If you're in Gmail, upload the folder once

1. Drag the whole folder of PDFs into Google Drive. The folder, not the files one at a time — that is the step people skip and then wonder why the add-on finds nothing.
2. Open your spreadsheet in Google Sheets. If it's a CSV, File → Import it into a new sheet.
3. Run the add-on and choose its import-from-a-folder option. It matches your rows to the files by name and fills the attachment column in itself. You are checking its work, not doing it.
4. Send a test to yourself.

The step that decides whether this goes wrong

All of it hangs on the file name in the row being the file name in the folder. That is the entire pairing. So:

• Put an identifier in the file name, not just a person's name. 920-07 2026-08.pdf can only be one row. Statement.pdf and Statement (1).pdf are how the wrong balance reaches the wrong person.
• Put the period in the file name too. Then pointing a merge at last month's folder finds nothing rather than quietly attaching last month's figures — a mismatch you can see beats a match you can't.
• Pick a tool that stops when an attachment is missing rather than sending the email without it. Not all of them do, and it is worth finding out on a test rather than on your client list.
• Check the count before you send. Rows in the sheet, files in the folder, and emails the add-in says it is about to send should be the same number. If they aren't, something didn't pair and the add-in may not tell you which.

A note on who the email comes from

All of these send through your account, which is the right way round. A statement about somebody's money should arrive from the business that holds it, from an address they recognise and can reply to. A financial document from a service they have never heard of, at an address that can't be replied to, looks exactly like a phishing email — and when it doesn't arrive, nobody finds out.

Getting the folder and the spreadsheet in the first place

Everything above assumes you already have a folder of per-person documents and a spreadsheet whose rows point at them. Making those by hand is the part that actually takes the afternoon.

If they're monthly investor statements out of a fund's own workbook, we build both from the workbook you already keep: monthly investor statements — a PDF per investor, named with their account code and the month, plus the spreadsheet with the email and attachment columns already filled in. Free, nothing is stored, and the file never leaves Australia.