Skip to content

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)

  1. Choose Mailings › Finish & Merge › Edit Individual Documents › All › OK.
  2. Scroll through the new document and check names, postal codes and blank lines.
  3. Fix problems in the source or main document, then merge again rather than editing letters by hand.

In the Word Exercises browser editor

  1. Choose Finish & merge… and set any filter or sort the task asks for.
  2. Choose Merge: the document is replaced by one letter per recipient, each on its own page.
  3. 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

Take the module 16 quiz

Last reviewed 2026-11-04. Word Exercises is independent and not affiliated with Microsoft.