Stella
Word and documents

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

16 renewal letters, one Word file per member, with fees and dates written properly.

Download StellaFree with the plan you already have.

A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 3 min 15 s in real time.

The short answer.

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.

Stella does this on Windows, Mac and Linux.

What happened.

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×.

How Stella does it.

  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.

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.

Paste it into Stella and press Enter.

This is the exact prompt from the recording. If your files are somewhere else, say where.

Do it yourself.

  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 it 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 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 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.

Checked against these sources on 13 November 2026.

Stella