# Mail merge from Excel to Word, with a separate file for each person

> Markdown version of https://stella.sh/how/documents/mail-merge-excel-to-word for agents and LLMs.
> Make one Word letter per row of an Excel sheet: Word's Mailings merge makes one big file, here's how to get separate ones, or let Stella (stella.sh) do both.

In Word, open your letter and use Mailings, Select Recipients, Use an Existing List to pick the Excel file, insert the merge fields, then Finish & Merge. Word puts every letter into one big document; separate files per person need a macro, a paid add-in or splitting it by hand. Stella (stella.sh) fills your template once per row and saves each letter as its own Word file named after the person.

- Checked: 13 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 13 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 16 letters in about 3 minutes 15 seconds. Checked afterwards against an answer key written before the run: one file per member, each named after them, every letter complete and correct (name, greeting, address, membership type, fee and renewal date) with no merge codes left, fees shown with pence, and the template and spreadsheet unchanged. The allotment society, its members and their addresses are fictitious, made for this run; the template uses real Word merge fields. The work is sped up 12×.

Video (53 s): https://stella.sh/media/proofs/documents/mail-merge-excel-to-word/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A Word letter template and a members spreadsheet are in Documents/Allotment society.
- 0:02 The prompt: a separate renewal letter for each member, saved as a Word document named after them.
- 0:20 Stella replies: one letter per member, the originals left unchanged, and it'll flag missing or odd details.
- 0:26 Filling in 16 letters and checking them, sped up 12×.
- 0:38 Done: 16 Word letters in a new folder, a preview of one, and a note about the capital letter in “Full plot”.

What Stella does:

1. Opens your letter template and the members spreadsheet in the folder you name, including Word merge fields like «First_Name» and «Renewal_Fee»
2. Fills a copy of the template for each of the 16 rows, keeping the template's layout
3. Writes fees as money with pence (£22.50, not 22.5) and dates the way people read them, not 2027-01-01 00:00:00
4. Saves each letter as a Word document named after the member, in a new Renewal letters 2027 folder, without changing the template or the spreadsheet
5. Shows one letter as it looks on the page, and points out a quirk: the membership type is capitalised mid-sentence because that's how the spreadsheet has it

## The prompt to paste

```text
Make a separate renewal letter for each member using my letter template and the members spreadsheet (they're in my Allotment society folder). Save each one as a Word document named after the member.
```

## Merge them yourself in Word

1. **Prepare the spreadsheet.** One header row, one row per person, no blank rows or merged cells. Give each column a plain name (First Name, Renewal Fee). Word reads the stored value, not the cell's formatting, so check fees and dates in the preview later.
2. **Connect the letter to Excel.** Open the letter in Word, choose Mailings, Select Recipients, Use an Existing List, and pick the workbook and sheet. Put the cursor where each detail goes and use Insert Merge Field. Preview Results shows a real filled-in letter.
3. **Fix fees and dates.** If a fee shows as 22.5 or a date as a long number, press Alt+F9 (Option+F9 on a Mac) to show field codes and add a format switch, such as `{ MERGEFIELD Renewal_Fee \# £0.00 }` or `{ MERGEFIELD Renewal_Date \@ "d MMMM yyyy" }`, then press it again to hide them.
4. **Finish & Merge.** Choose Finish & Merge, Edit Individual Documents, All. Word makes one new document holding every letter, separated by section breaks. Save it; this is the version you'd print in one go.
5. **Split it into one file per person.** Word has no button for this. Copy each letter into its own document and save it under the person's name, or save the merged document as a PDF and split that by page range. For dozens of people, a VBA macro or a paid add-in automates it.

## Where Stella stops

- Stella fills the template it's given and keeps its layout. Word IF fields, a different picture per person or optional paragraphs weren't part of this test; describe the rule in your prompt.
- It copied values exactly as typed, so “Full plot” kept its capital letter mid-sentence. It pointed this out and offered to fix it; tidy the spreadsheet first if the wording matters.
- It makes the letters. It doesn't print, email or post them.
- Names and addresses from the spreadsheet go to the AI model you use in Stella. For member or customer data, choose your model accordingly.
- Recorded on Linux without Word installed. The letters are ordinary .docx files that open in Word, Pages or Google Docs.

## Questions

**Can Word mail merge into separate documents?**
Not by itself. Finish & Merge makes one document holding every letter. Separate files take a macro, an add-in, splitting by hand, or a tool that writes each file directly, as Stella did here.

**Why does my mail merge show 22.5 instead of £22.50?**
Word merges the raw number from Excel, not how the cell is formatted. Add a number switch to the field, `\# £0.00`, or store the fee as text in the spreadsheet.

**Can I get a PDF per person instead?**
Yes. Ask Stella for PDFs, or in Word save the merged document as a PDF and [split it into one file per letter](https://stella.sh/how/pdf-excel/split-pdf-into-multiple-files) by page range.

**Does it work with Google Sheets or a CSV?**
Yes, download the sheet as .xlsx or .csv; Word's merge reads both, and so does Stella. If your list is spread over several files, [combine them into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet) first.

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Microsoft: Use mail merge for bulk email, letters, labels and envelopes](https://support.microsoft.com/en-us/office/use-mail-merge-for-bulk-email-letters-labels-and-envelopes-f488ed5b-b849-4c11-9cff-932c49474705), [Microsoft: Format field results (field switches)](https://support.microsoft.com/en-us/office/format-field-results-baa61f5a-5636-4f11-ab4f-6c36ae43508c), [Ablebits: Mail merge from Excel to Word](https://www.ablebits.com/office-addins-blog/mail-merge-excel-word/).

## Related problems

- [Combine multiple Excel files into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet.md)
- [Compare two Excel sheets and list what changed](https://stella.sh/how/pdf-excel/compare-two-excel-files.md)
- [Split a PDF into multiple files (one per document)](https://stella.sh/how/pdf-excel/split-pdf-into-multiple-files.md)
- [Generate invoices from a spreadsheet, one per customer](https://stella.sh/how/documents/generate-invoices-from-spreadsheet.md)
- [Print address labels from Excel on Avery 5160 sheets](https://stella.sh/how/printing-labels/print-address-labels-from-excel.md)
- [Generate certificates from an Excel list, one per person](https://stella.sh/how/printing-labels/make-certificates-from-excel.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
