Mail Merge in MS Word
Mail Merge helps create many personalized documents from one common template. It is useful for letters, certificates, labels, admission confirmations, invitations and official communication.
Main Document
The common letter or certificate template used for all records.
Data Source
The list of names, addresses or details used for merging.
Merge Fields
Placeholders like Name, Course and Date inserted in the template.
Final Output
Personalized letters, labels, certificates or emails.
After This Chapter, You Will Be Able To
This chapter helps you create personalized documents quickly and accurately.
Main Document
Understand the common template used for merging.
Data Source
Prepare a list of records for personalized output.
Merge Fields
Insert placeholders into the document template.
Finish Merge
Preview and generate final personalized documents.
What is Mail Merge?
Mail Merge creates many personalized documents from one template and one data list.
1 Easy Explanation
Mail Merge is used when the same document must be sent to many people with small changes, such as name, address, course, date, certificate number or fee details.
2 Simple Example
An institute wants to send admission confirmation letters to 50 students. The letter format is the same, but student name, course name and admission date are different. Mail Merge can create all 50 letters automatically.
Main Document, Data Source and Merge Fields
Mail Merge works with three important parts.
Main Document
The common template, such as a letter, certificate or label design.
Data Source
The list of records, usually created in Excel, Word table or Outlook contacts.
Merge Fields
Placeholders inserted into template, such as «Name» and «Course».
Merged Output
The final personalized documents generated from the template and data.
Step-by-Step Mail Merge Process
Follow this workflow to complete Mail Merge correctly.
1. Create
Create the main document template.
2. Select
Select or create the data source.
3. Insert
Insert merge fields in correct places.
4. Preview
Preview results and check records.
5. Finish
Finish and merge to print or edit documents.
Preparing a Data Source
A clean data source is the most important part of successful Mail Merge.
Sample Student Data Source
| StudentName | CourseName | AdmissionDate | BatchTime |
|---|---|---|---|
| Amit Sharma | MS Office Applications | 12 May 2026 | 10:00 AM |
| Priya Verma | MS Excel | 13 May 2026 | 12:00 PM |
| Rahul Gupta | MS Word | 14 May 2026 | 04:00 PM |
3 Good Data Source Rules
- Use clear column headings.
- Do not leave blank headings.
- Keep one record in one row.
- Check spelling of names carefully.
- Use consistent date format.
- Remove duplicate records before merging.
4 Common Merge Fields
- StudentName
- CourseName
- AdmissionDate
- BatchTime
- CertificateNo
- InstituteName
Where Mail Merge is Used
Mail Merge is useful in institutes, offices, businesses and organizations.
| Use Case | Document Type | Personalized Fields |
|---|---|---|
| Admission confirmation | Letter | Name, Course, Date, Batch |
| Course completion | Certificate | Name, Course, Certificate No. |
| Fee reminder | Notice | Name, Balance, Due Date |
| Event invitation | Invitation letter | Name, Event, Venue, Time |
| Address labels | Labels | Name, Address, City, PIN |
Example: Admission Confirmation Letter
Mail Merge converts a template into a personalized letter.
Main Document Template
Your admission in «CourseName» is confirmed from «AdmissionDate».
Your batch timing is «BatchTime».
Regards,
AICPE Learning Hub
Merged Letter Output
Admission Confirmation
Dear Amit Sharma,Your admission in MS Office Applications is confirmed from 12 May 2026.
Your batch timing is 10:00 AM.
Regards,
AICPE Learning Hub
Preview Mail Merge Results
Click student names to preview how merge fields change automatically.
Your admission in «CourseName» is confirmed from «AdmissionDate».
Your batch timing is «BatchTime».
Regards,
AICPE Learning Hub
Create Personalized Admission Confirmation Letters
Complete these steps inside MS Word with a small student list.
Office Task: Student Admission Mail Merge
Mistakes Students Should Avoid
Mail Merge needs clean data and careful preview before final output.
Wrong Habits
- Using unclear column headings in data source.
- Leaving blank rows or columns in data list.
- Inserting wrong merge field in the letter.
- Not previewing results before printing.
- Mixing up names and course fields.
- Printing all letters without checking formatting.
Correct Habits
- Use clear and simple field names.
- Keep data source clean and complete.
- Insert merge fields carefully.
- Preview every record before final merge.
- Check names, dates and course details.
- Save both template and final merged document.
Quick Quiz
Select the correct answers and check your score.
1. Mail Merge is used to create:
2. The common template in Mail Merge is called:
3. A data source contains:
4. Merge fields are:
5. Which tab is commonly used for Mail Merge in MS Word?
6. What should be done before finishing the merge?
7. Which is a good data source heading?
8. Mail Merge can be used for:
9. Which is a common Mail Merge mistake?
10. Best professional habit in Mail Merge is:
Remember These Points
Revise these before moving to Chapter 12.
Mail Merge
Creates personalized documents from one template and one data source.
Main Document
The common letter, certificate or label template.
Data Source
The list of records used to personalize the output.
Merge Fields
Placeholders like StudentName, CourseName and Date.
Preview Results
Shows final personalized documents before merging.
Professional Habit
Keep data clean and verify every record before final output.