Module 16: Mail merge with fictional recipients · Lesson 3 of 4 · 7 min
Filtering and sorting recipients
You will learn to: Merge only the right recipients in the right order.
Helpful first: Previewing results
Filter the recipient list (for example Attending = Yes) and sort it (for example by LastName) before merging. The merge then produces only the letters you need, already in order.
Deleting unwanted letters afterwards, or shuffling merged pages, is slow and error-prone: one wrong deletion and a guest gets no invitation.
Worked example
- Before
- Everyone merged, then the non-attending guests’ pages deleted by hand — one was missed.
- After
- Filter Attending equals Yes applied before merging; only attending guests get letters.
- Why it matters
- Only the intended letters are produced.
How to do it
In Microsoft Word (Microsoft 365, Windows and Mac)
- Choose Mailings › Edit Recipient List.
- Choose Filter, set Field: Attending, Comparison: Equal to, Compare to: Yes; or choose Sort and pick the column.
- Choose OK and preview a few records to confirm the list.
In the Word Exercises browser editor
- Choose Finish & merge… in the Mailings group.
- Under Filter, choose the Column and type the value it must equal (e.g. Attending equals Yes); under Sort, choose the column and A to Z or Z to A.
- Choose Merge and check the letters; Undo returns to the main document if you need to change the options.
Menu names follow the Microsoft 365 ribbon as of 2026; older versions may label commands differently.
Common mistakes
- Sorting the merged pages instead of the data.
- Deleting letters after merging instead of filtering.
Practise
- Merge only the recipients who are attending — guided · 7 min · Pro
- Merge letters in surname order — independent · 7 min · Pro
- Produce invitations for attending guests — independent · 12 min · Pro
Guides on this topic
Last reviewed 2026-11-04. Word Exercises is independent and not affiliated with Microsoft.