# Print envelopes from an Excel guest list, one per household

> Markdown version of https://stella.sh/how/printing-labels/print-envelopes-from-excel for agents and LLMs.
> Print wedding or holiday envelopes straight from a guest list, one per household, return address top left: Word's envelope merge step by step, or Stella (stella.sh).

Make a copy of the guest list with one row per household (Data, Remove Duplicates on the envelope name and address), then in Word use Mailings, Start Mail Merge, Envelopes, pick the envelope size, type your return address, use the spreadsheet as the list, insert the address and finish the merge. Stella (stella.sh) does it from the guest list on your computer and writes a PDF with one envelope-sized page per household.

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

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 31 envelopes in under two minutes. Checked afterwards against an answer key written before the run: every page A7 size in landscape, exactly one envelope for each of the 31 households and none per guest, name, street and city, state and ZIP (leading zero kept) on each, the address in the middle, the return address in the top-left corner of every envelope, the list's order kept, and the guest list unchanged. The couple, guests and addresses are made up for this run. No envelopes were printed, so how a particular printer feeds them wasn't tested. The work is sped up 5×.

Video (43 s): https://stella.sh/media/proofs/printing-labels/print-envelopes-from-excel/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. The wedding guest list is in Documents.
- 0:02 The prompt: A7 envelopes, one per household, with the couple's return address top left.
- 0:11 Stella replies: it will combine guests into households and make a print-ready A7 file.
- 0:17 Grouping households and laying out the envelopes, sped up 5×.
- 0:28 Done: 31 envelopes, ZIP zeros put back, with a note on six “and Guest” envelopes.

What Stella does:

1. Finds `Wedding guest list.xlsx` in Documents: 68 guests, one row each, with the household's envelope name and address repeated on every row
2. Groups the guests into 31 households, keeping two families who share a surname but live at different addresses apart, and counting a guest listed twice once
3. Puts back the leading zero on Massachusetts, Vermont and Connecticut ZIP codes that the spreadsheet had dropped
4. Makes one 7.25 × 5.25 in (A7) landscape page per household, in list order, with the name and address centred and the couple's return address in the top left
5. Saves `Wedding envelopes - A7.pdf` in Documents, suggests dropping “and Guest” from six outer envelopes, and says to print at actual size with one test envelope first

## The prompt to paste

```text
We're mailing our wedding invitations in A7 envelopes. From the guest list in my Documents, make a file I can print straight onto the envelopes, one per household, with our return address in the top left: Priya Nandakumar & Theo Marsh, 418 Alder Creek Road, Bellmont, OR 97321.
```

## Print them yourself

1. **One row per household.** Copy the guest sheet to a new tab. Select it and use Data, Remove Duplicates, ticking the envelope name and street columns, so a family of four becomes one row. Check families with the same surname at different addresses are still separate.
2. **Keep ZIP codes as five digits.** If a ZIP like 02134 shows as 2134 in the formula bar, add a column with `=TEXT(F2,"00000")`, fill it down and Paste Values over the ZIPs, or the merge prints four digits.
3. **Set up the envelope merge in Word.** Mailings, Start Mail Merge, Envelopes. Choose the size (A7 is 7¼ × 5¼ in; a #10 business envelope is 9½ × 4⅛ in) and type your return address. Then Select Recipients, Use an Existing List, open the household tab, and insert the name and address fields in the middle box.
4. **Test one envelope, then print.** Finish & Merge, Edit Individual Documents. Print the first page on one envelope, or on paper cut to size, to learn which way up and which flap side your printer wants. Print the rest at 100%, a few at a time.

## Where Stella stops

- Printers feed envelopes differently (face up or down, flap left or right) and some can't take thick ones. Test with one envelope first.
- Stella decides what a household is from the names and addresses in the list and says how it grouped them; check its notes before printing 31 envelopes.
- Names and addresses go to the AI model you use in Stella while it reads the list. The PDF is made on your computer.
- It makes the file; it doesn't print it unless you ask. It also doesn't change etiquette like “and Guest” unless you tell it to.
- Recorded on Linux, where Stella used Python and a browser already on the computer to write the PDF. On a Mac or Windows PC it may install Python first, which wasn't recorded.

## Questions

**What size is an A7 envelope?**
7¼ × 5¼ inches, the usual envelope for 5 × 7 invitations. Name your envelope's size or give its measurements and the pages are made to match.

**Should the return address be on the front or the back flap?**
Either is accepted for mail in the US; top left on the front is easiest to print. For the back flap, ask for a separate pass that prints only the return address.

**Can I print address labels instead?**
Yes: see [address labels from Excel](https://stella.sh/how/printing-labels/print-address-labels-from-excel) for Avery 5160 sheets.

**What else can it make from the guest list?**
The headcount, seating chart and place cards: see [count wedding RSVPs](https://stella.sh/how/weddings-events/count-wedding-rsvps) and [make a wedding seating chart](https://stella.sh/how/weddings-events/make-wedding-seating-chart).

**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 Support: Mail merge with envelopes](https://support.microsoft.com/en-us/word/mail-merge-with-envelopes), [Microsoft Support: Filter for unique values or remove duplicate values](https://support.microsoft.com/en-us/office/filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2).

## Related problems

- [Print address labels from Excel on Avery 5160 sheets](https://stella.sh/how/printing-labels/print-address-labels-from-excel.md)
- [Count wedding RSVPs when some guests replied twice](https://stella.sh/how/weddings-events/count-wedding-rsvps.md)
- [Mail merge from Excel to Word, with a separate file for each person](https://stella.sh/how/documents/mail-merge-excel-to-word.md)
- [Make name tags from a registration list](https://stella.sh/how/printing-labels/make-name-tags-from-a-list.md)
- [Generate certificates from an Excel list, one per person](https://stella.sh/how/printing-labels/make-certificates-from-excel.md)
- [Make a QR code for every link in a spreadsheet, in bulk](https://stella.sh/how/printing-labels/make-qr-codes-in-bulk.md)

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