Function of mail merge
Gndupapers.com
What is the function of the ‘Mail Merge’ feature in Microsoft Word? Explain by taking suitable examples.
The Mail Merge feature in Microsoft Word is used to create many documents of the same type (like letters, certificates, address labels, hall tickets, etc.) where the main content is same, but some information changes for each person, such as:
- Name
- Address
- Roll number
- Marks
- Membership ID, etc.
Instead of typing each document separately, Mail Merge automatically inserts this changing information from a list (data source) into your Word document. Function of mail merge
1. Function of Mail Merge (What it does)
Mail Merge helps you to:
- Create multiple personalised documents quickly
One single main document + a list of data = many final personalised copies.
- Avoid typing the same content again and again
You write the common content only once.
- Reduce mistakes
Since data comes from a prepared list (like Excel), chances of spelling and typing errors are less.Function of mail merge
- Maintain uniform format
All letters/certificates look the same in style and layout, only the specific details (like name, marks, etc.) change. Function of mail merge
- Save time and effort
Especially useful for offices, schools, businesses where the same type of document is needed for many people.
2. Basic components used in Mail Merge
Mail Merge mainly uses two things:
- Main Document (Form Letter / Template)
- This is the Word file in which the common content is written.
- Example: A letter format from principal to students, or a fee reminder notice. Function of mail merge
- Data Source (Address List / Table of Records)
- This contains variable information in a tabular form (rows and columns).
-
It can be:
- An Excel sheet
- A table created in Word
- Outlook Contacts
- Or a new list created inside Word
- Each row = one person (one record)
- Each column = one field like Name, Class, Roll No, Address etc. Function of mail merge
- Merge Fields
- These are placeholders in the main document where data from the data source will be inserted.
- Example fields: «Name», «Address», «Roll_No», «Marks» etc.
3. Example to Explain Mail Merge (School Example)
Situation
Suppose you are a teacher or principal and you want to send a “Result Intimation Letter” to 50 students.
-
The main body of the letter is the same for all students.
-
But details like:
- Student Name
- Father’s Name
- Class
- Roll No
- Total Marks
- Result (Pass/Fail)
-
are different for each student.
Instead of typing 50 letters separately, you can use Mail Merge.
4. Step-by-step Explanation (Conceptual)
Step 1: Prepare the Data Source
First, create a list of students with their details.
You can make this in Excel or inside Word. Function of mail merge
Example table (in Excel):
Name | Father_Name | Class | Roll_No | Total_Marks | Result |
|---|---|---|---|---|---|
Rohan Kumar | Mr. Rajesh Kumar | 10th | 21 | 450 | Pass |
Neha Sharma | Mr. Vinod Sharma | 10th | 22 | 380 | Pass |
Aman Singh | Mr. Surjit Singh | 10th | 23 | 295 | Fail |
- Save this file, e.g., Result_List.xlsx.
This is your Data Source.
Step 2: Create the Main Document in Word
Open Microsoft Word and type the common format of the letter.
Example:
To
«Name»
S/o, D/o «Father_Name»
Class: «Class»
Roll No: «Roll_No»
Subject: Result Intimation
Dear «Name»,
This is to inform you that your result for the annual examination has been declared. Your total marks are «Total_Marks». Your overall result is: «Result». Function of mail merge
You are advised to meet your class teacher for further guidance.
Regards,
Principal
XYZ School
In the above example, the fields like «Name», «Father_Name», «Class», «Roll_No», «Total_Marks», «Result» are merge fields (placeholders). Function of mail merge
Step 3: Link Data Source with Main Document
In Word (conceptually):
- Go to the Mailings tab.
- Click on Start Mail Merge → choose Letters.
-
Click on Select Recipients → choose:
- Use an Existing List… (then browse and select Result_List.xlsx), or
- Type a New List… (and make the table inside Word).
After selecting, Word connects your main document with your data source.
Step 4: Insert Merge Fields
Place your cursor where you want to insert a student’s name in the letter.
Then:
- Go to the Mailings tab.
- Click Insert Merge Field.
-
Choose the field like:
- Name
- Father_Name
- Class
- Roll_No
- Total_Marks
- Result
These appear in the document as «Name», «Class», etc. Function of mail merge
Step 5: Preview the Letters
Now click Preview Results in the Mailings tab.
- Word will show how the letter looks for the first student.
- You can move to the next record (student) using navigation buttons.
-
You will see that:
- The letter content is same,
- But Name, Class, Roll No, Marks, etc. change as per data source.
Step 6: Complete the Merge
Finally, to get all letters:
- Click Finish & Merge.
-
Choose:
- Edit Individual Documents… → Word creates a new document with all 50 letters, each on a separate page.
- Print Documents… → Directly print all letters.
- Send E-mail Messages… → If you are doing email merge (for e-mail IDs).
Now each student has a separate personalized letter without you typing each letter manually.
5. One More Simple Example (Invitation Letters)
Suppose you are sending invitation letters to 100 parents for a Parent-Teacher Meeting.
- Common text: Date, venue, time, purpose of meeting, etc.
- Changing data: Parent Name, Student Name, Class, Address.
Using Mail Merge, you:
- Create a list of parents with details in Excel or Word list.
- Create a main invitation letter in Word with merge fields like «Parent_Name», «Student_Name», «Class», «Address».
- Link data source, insert fields, and merge.
Result: You get 100 personalized invitation letters automatically. Function of mail merge
6. Conclusion
- Mail Merge is a feature of MS Word that is used to create multiple personalized documents (like letters, certificates, envelopes, labels) where the main text is the same but some fields change for each recipient.
-
It uses:
- Main Document → contains the common text and merge fields.
- Data Source → contains variable data in table form (like name, address, roll no., etc.).
- The main function of Mail Merge is to combine (merge) the main document with each record from the data source and generate separate documents for each person.
- It is very useful in schools, offices, banks, businesses for sending bulk letters, result sheets, reminders, fee notices etc., and helps in saving time, reducing errors, and maintaining uniformity. Function of mail merge
If you would like to know the syllabus of the Computer Fundamentals you must visit the official website of Gndu.
👉 Note:- Important questions of computer Fundamental
