Module 16: Mail merge with fictional recipients
Map data fields, preview recipients and produce correct per-recipient output — with fictional data only.
Lessons
- 1. Merge fields in the main document · 8 min — Insert merge fields where each recipient’s details should appear.
- 2. Previewing results · 5 min — Check merged output for several records before merging.
- 3. Filtering and sorting recipients · 7 min — Merge only the right recipients in the right order.
- 4. Finishing the merge and checking data · 6 min — Produce one letter per recipient and check tricky data survived.
Guides on this topic
Practice exercises
Replace a typed name with a merge field
Beginner · 5 min · Free
A typed name sends every recipient the same greeting.
Build an address from merge fields
Intermediate · 8 min · Free
Leaving out the space between fields runs the first and last names together.
Fix a greeting that uses the wrong field
Beginner · 4 min · Free
“Dear «LastName»,” addresses every recipient by surname only.
Merge letters for every recipient
Intermediate · 6 min · Pro
Copying the letter and retyping each name by hand is slow and error-prone.
Merge only the recipients who are attending
Intermediate · 7 min · Pro
Deleting unwanted letters afterwards is easy to get wrong; filter the recipient list first.
Merge letters in surname order
Advanced · 7 min · Pro
Sorting the merged pages by hand breaks letters apart; sort the recipient list before merging.
Fix a missing space between merge fields
Beginner · 5 min · Free
Fields placed side by side print as “AmiraHaddad” unless you type a space between them.
Keep leading zeros in merged postal codes
Intermediate · 6 min · Pro
Postal codes like 02118 lose their leading zero if the data is treated as numbers.