Skip to content

All exercises

Module 16: Mail merge with fictional recipients

Map data fields, preview recipients and produce correct per-recipient output — with fictional data only.

Lessons

  1. 1. Merge fields in the main document · 8 min — Insert merge fields where each recipient’s details should appear.
  2. 2. Previewing results · 5 min — Check merged output for several records before merging.
  3. 3. Filtering and sorting recipients · 7 min — Merge only the right recipients in the right order.
  4. 4. Finishing the merge and checking data · 6 min — Produce one letter per recipient and check tricky data survived.

Module 16 quiz (8 questions)

Guides on this topic

Practice exercises

  1. Replace a typed name with a merge field

    Beginner · 5 min · Free

    A typed name sends every recipient the same greeting.

  2. Build an address from merge fields

    Intermediate · 8 min · Free

    Leaving out the space between fields runs the first and last names together.

  3. Fix a greeting that uses the wrong field

    Beginner · 4 min · Free

    “Dear «LastName»,” addresses every recipient by surname only.

  4. Merge letters for every recipient

    Intermediate · 6 min · Pro

    Copying the letter and retyping each name by hand is slow and error-prone.

  5. 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.

  6. Merge letters in surname order

    Advanced · 7 min · Pro

    Sorting the merged pages by hand breaks letters apart; sort the recipient list before merging.

  7. 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.

  8. 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.