Mail Merge in Word Step by Step

Mail merge in Word creates many personalised documents from one template and a list of details in Excel. You write a letter (or certificate or label) once, insert merge fields where the name, address or marks should go, then merge with your Excel list. Word produces one document per row, each with the right details filled in. It turns a task that would take hours, like 200 personalised certificates, into a few minutes of work.

What you need

• A main document in Word (the letter or certificate template).
• A data source, usually an Excel sheet where row 1 has headings (Name, Course, Date…) and each row is one recipient.

Keep the Excel headings clean and simple; they become your merge fields.

Step by step: mail merge a letter

1. Open Word, write the letter, leaving blanks where personal details go.
2. Go to the Mailings tab ▸ Start Mail Merge ▸ Letters.
3. Click Select Recipients ▸ Use an Existing List, and choose your Excel file (and the sheet).
4. Place the cursor where a detail goes, click Insert Merge Field, and pick the field (e.g. «Name»).
5. Repeat for every detail (Course, Date, etc.).
6. Click Preview Results to see it filled with real data; use the arrows to check different recipients.
7. Click Finish & Merge ▸ Edit Individual Documents (to review) or Print Documents.

The Excel list

Your Excel data should look like this:

Row 1 holds the field names. Word matches «Name», «Course» and «Date» to these columns.

Worked example (course certificates)

You need to print 50 certificates. You:

1. Design one certificate in Word with blanks for name and course.
2. Keep the 50 names and courses in Excel.
3. Start Mail Merge ▸ Letters, select the Excel list.
4. Insert «Name» and «Course» in the right places.
5. Preview, then Finish & Merge ▸ Print.

Fifty personalised certificates, printed in one go.

Merge to email

Instead of printing, you can email each person. In Finish & Merge, choose Send Email Messages, pick the email field, add a subject, and Word sends a personalised email to each recipient (through Outlook).

Pro tips

• Get the Excel headings right first; they become your merge fields and are annoying to change later.
• Always Preview Results before printing, to catch a wrong field or a blank.
• Save the main document and the Excel list; you can re-run the merge anytime the list changes.

Common mistakes

• Messy Excel headings. Merge fields come from row 1, so keep it clean (Name, not "Full Name of Student (as per record)").
• Not previewing. A misplaced field prints 200 wrong copies. Always preview first.
• Wrong sheet selected. If your data is on Sheet2, make sure you pick that sheet when selecting recipients.

Key takeaways

• Mail merge makes many personalised documents from one template plus an Excel list.
• Start Mail Merge ▸ Select Recipients ▸ Insert Merge Fields ▸ Preview ▸ Finish & Merge.
• Excel row 1 headings become the merge fields.
• You can print, save, or email the merged documents.

Practice task

Make an Excel list of five names and courses. In Word, write a short "Certificate of Completion" with «Name» and «Course» merge fields. Preview all five, then merge to individual documents.

Learn time-saving office skills like mail merge in the Basic Computer Course (BCC) at HCI.