Module 16: Mail merge with fictional recipients · Lesson 4 of 4 · 6 min
Finishing the merge and checking data
You will learn to: Produce one letter per recipient and check tricky data survived.
Helpful first: Filtering and sorting recipients
Finish & Merge › Edit Individual Documents creates a new document with one letter per record, each starting on a new page (Word separates them with section breaks). Check the result before printing or sending.
Look at data that often breaks: postal codes with leading zeros (store them as text in the source, or 02118 becomes 2118), names with apostrophes and non-ASCII characters, and optional lines that should disappear when empty.
Worked example
- Before
- Postal code 02118 merged as 2118 because the spreadsheet column was a number.
- After
- The source column is formatted as text, so every letter shows 02118.
- Why it matters
- The data type in the source decides what merges.
How to do it
In Microsoft Word (Microsoft 365, Windows and Mac)
- Choose Mailings › Finish & Merge › Edit Individual Documents › All › OK.
- Scroll through the new document and check names, postal codes and blank lines.
- Fix problems in the source or main document, then merge again rather than editing letters by hand.
In the Word Exercises browser editor
- Choose Finish & merge… and set any filter or sort the task asks for.
- Choose Merge: the document is replaced by one letter per recipient, each on its own page.
- Check every letter; use Undo to return to the main document if something needs fixing, then merge again.
Menu names follow the Microsoft 365 ribbon as of 2026; older versions may label commands differently.
Common mistakes
- Treating postal codes as numbers.
- Fixing merged letters by hand instead of fixing the source.
Practise
- Merge letters for every recipient — guided · 6 min · Pro
- Keep leading zeros in merged postal codes — independent · 6 min · Pro
Last reviewed 2026-11-04. Word Exercises is independent and not affiliated with Microsoft.