Mail Merge Basics
Learn how to use Mail Merge in Word to automatically generate personalized letters, envelopes, and labels from a data source.
By the end of this lesson you can
- Explain the roles of the main document and the data source
- Run a mail merge from start to finish using the Mailings tab
- Preview merged results and catch data problems before printing
- Judge when mail merge saves time and when it is overkill
Video
Watch the lesson video, then complete the reading and challenge.
Lesson Notes
Read through the key concepts before you try the challenge.
One letter, many recipients, no retyping
You handle recall notices at Lakeside Medical Associates.
Two hundred and forty patients are due for an annual visit. Each needs a letter with their name, address, and appointment date. Typed individually, that is two full days of work and a guarantee that at least one letter carries the wrong name.
Your task: Produce all 240 personalized letters from one template and one list, in about fifteen minutes.
Mail merge combines two things. The main document is the letter — everything that stays the same, plus merge fields marking where personal data belongs. The data source is the list — a Word table, an Excel sheet, or Outlook contacts — with one row per recipient and one column per field. Merging produces one output letter per row.
Most merge failures are data problems, not Word problems. Your data source needs a clean header row where every column has a distinct name, no blank rows in the middle, and consistent formatting — because whatever is in the cell is what appears in the letter. A date stored as text as '3/4' will print as '3/4', not as March 4.
Producing 240 recall letters
Merge a recall letter template with a patient list, verifying the output before anything reaches the printer.
- 1
Prepare the data source first, and open it to check it.
The merge inherits every flaw in the list. Confirm one header row, distinct column names, no blank rows, and dates formatted the way they should appear. Fixing this after generating 240 letters means generating them again.
- 2
Mailings > Start Mail Merge > Letters, then Select Recipients > Use an Existing List.
This binds the letter to the data. Choosing Letters as the type tells Word to produce one page per record, as opposed to labels or envelopes, which lay out several records per sheet.
- 3
Insert merge fields where personal data belongs, including the address block.
Fields appear in chevrons as «FirstName». Use Address Block rather than assembling address lines from individual fields — it handles missing second address lines correctly instead of leaving a blank line in the middle of the address.
- 4
Click Preview Results and step through several records, including the last one.
This is the step that catches everything: a missing surname, a date that came through as a serial number, a patient whose name overflows the line. Check the first, a few in the middle, and the last — the last record is where truncated data sources reveal themselves.
- 5
Finish & Merge > Edit Individual Documents, not straight to print.
This produces a single document containing all 240 letters, which you can scroll and check before committing paper. Printing directly from the merge means the first sign of a problem is a stack of wrong letters.
Result: 240 verified personalized letters produced in one pass, checked before printing.
Clean the data first, preview several records including the last, and merge to a document before merging to the printer.
What Is Mail Merge?
Mail Merge combines a letter template (the main document) with a list of recipients (the data source) to automatically produce personalized copies. It is commonly used for form letters, address labels, and name badges.
Step 1 – Start the Mail Merge
Go to Mailings → Start Mail Merge and choose the document type: Letters, Envelopes, Labels, or Email Messages. For this lesson, select Letters.
Step 2 – Select Recipients
Click Select Recipients on the Mailings tab. Choose Use an Existing List to connect an Excel spreadsheet or CSV file as your data source. Navigate to the file and click Open, then select the correct sheet.
Step 3 – Insert Merge Fields
Place your cursor in the document where you want personalized data (such as the recipient's name). Click Insert Merge Field on the Mailings tab and choose the field from your data source, such as FirstName or City.
Step 4 – Preview Results
Click Preview Results on the Mailings tab to see how the first recipient's data fills in. Use the arrow buttons to cycle through all records and confirm the merge looks correct.
Step 5 – Finish & Merge
Click Finish & Merge on the Mailings tab. Choose Edit Individual Documents to create a new document with all personalized copies combined, or Print Documents to send them directly to the printer.
Knowledge Check
What is the role of the data source in a Mail Merge?
Practice File
Download this file and follow along with the lesson.
Challenge
Apply what you've learned in this lesson.
Complete the following tasks:
- Open the letter template practice file and start a Letters mail merge.
- Connect the provided Excel data source file as your recipient list.
- Insert merge fields for FirstName, LastName, and City in the appropriate places in the letter.
- Use Preview Results to check that the first three records display correctly.
- Use Finish & Merge → Edit Individual Documents to produce the complete set of letters.
Finished this lesson?
Progress is saved in this browser only. It is not a grade — official progress lives in Brightspace.