Introduction

Mail Merge is a powerful feature of Microsoft Word that allows you to create multiple personalized documents from a single main document and a list of data.

Instead of typing the same letter, certificate, invitation, or notice separately for every person, Mail Merge automatically combines the document with individual information such as name, address, phone number, course, or email.

Example

Suppose an institute needs to send an admission letter to 100 students.

Without Mail Merge, you would have to create 100 letters manually.

With Mail Merge, you create one letter and connect it to a student data list. Word automatically creates a separate personalized letter for each student.

1. What is Mail Merge?

Mail Merge is a Microsoft Word feature used to create multiple documents containing different personal information while keeping the main content the same.

Common Uses

Mail Merge can be used for:

• Admission letters
• Appointment letters
• Certificates
• Invitation letters
• Salary letters
• Notices
• Address labels
• Envelopes
• Promotional letters
• Student information letters
• Email messages

2. Main Components of Mail Merge

Mail Merge generally works with three important components.

1. Main Document

The Main Document contains the common content that will appear in every copy.

Example:

Dear Student,
You have successfully enrolled in the ADCA Computer Course.

The wording remains the same for every student.

2. Data Source

The Data Source contains individual information about each person.

Example:

3. Merge Fields

Merge Fields are placeholders that tell Word where to insert information from the data source.

Examples:

• «Name»
• «Course»
• «Phone»
• «City»

3. How Mail Merge Works

The basic process is:

Main Document + Data Source + Merge Fields → Personalized Documents

For example:

Main Document:

Dear «Name»,
You have successfully enrolled in the «Course» course.

After merging:

Dear Rahul Sharma,
You have successfully enrolled in the ADCA course.

Another record might become:

Dear Priya Verma,
You have successfully enrolled in the Tally Prime course.

4. Preparing the Data Source

The data source is usually prepared in Microsoft Excel or directly in Word.

Example Excel Data

Important Points

When preparing data:

• Keep column headings clear.
• Avoid blank rows in the middle of the data.
• Keep each person’s information in one row.
• Use consistent formatting.
• Save the Excel file before starting the merge.

5. Starting Mail Merge

Steps

1. Open Microsoft Word.
2. Create or open the main document.
3. Go to the Mailings tab.
4. Click Start Mail Merge.
5. Select the required document type.

Common options include:

• Letters
• Email Messages
• Envelopes
• Labels
• Directory

6. Selecting the Data Source

After selecting the Mail Merge type, you need to connect the document to your data.

Steps

1. Go to Mailings.
2. Click Select Recipients.
3. Choose Use an Existing List.
4. Select the Excel file.
5. Select the required worksheet.
6. Confirm that the first row contains column headings.

Word will now connect the Excel data with your document.

7. Inserting Merge Fields

Merge fields are inserted wherever personalized information is required.

Example Letter

Dear «Name»,

We are pleased to inform you that you have enrolled in the «Course» course.

Course Duration: «Duration»

Contact Number: «Phone»

Steps

1. Place the cursor where the information is required.
2. Go to Mailings.
3. Click Insert Merge Field.
4. Select the required field.
5. Repeat the process for other information.

8. Previewing the Results

Before completing the merge, you should check how the personalized documents will appear.

Steps

1. Open the Mailings tab.
2. Click Preview Results.
3. Use the navigation arrows to view different records.
4. Check names, courses, addresses, phone numbers, and other fields.

Why Preview is Important

Previewing helps identify:

• Incorrect field placement
• Missing information
• Spelling mistakes
• Wrong data
• Formatting problems

9. Editing the Recipient List

Word allows you to control which recipients will be included.

Steps

1. Go to Mailings.
2. Click Edit Recipient List.
3. Select or deselect recipients.
4. Apply sorting or filtering if required.
5. Click OK.

Example

If your Excel sheet contains 100 students but you want to send letters only to students enrolled in ADCA, you can filter the recipient list.

10. Filtering Recipients

Filtering allows you to select only specific records from the data source.

Example

Suppose your data contains:

You can filter the list to show only:

Course = ADCA

The Mail Merge will then create documents only for the selected students.

11. Sorting Recipients

Sorting arranges recipients according to a selected field.

For example, you can sort recipients by:

• Name
• City
• Course
• Registration Number
• Date

This is useful when creating organized reports, labels, or letters.

12. Using Address Information

Mail Merge can also be used to create letters containing complete addresses.

Example

To:
«Name»
«Address»
«City»
«Pincode»

This is especially useful for:

• Official letters
• Notices
• Invitations
• Business communication

13. Completing the Mail Merge

After checking the preview, you can complete the merge.

Steps

1. Go to Mailings.
2. Click Finish & Merge.
3. Choose the required option.

Common options include:

• Edit Individual Documents
• Print Documents
• Send Email Messages

Edit Individual Documents

This creates a new Word document containing the merged records.

Print Documents

This sends the merged documents to the printer.

Send Email Messages

This can be used to send personalized email messages when the required email data and supported email setup are available.

14. Mail Merge with Certificates

Mail Merge can also help create personalized certificates.

Data Source

Certificate Template

CERTIFICATE OF COMPLETION

This certificate is proudly presented to
«Name»

for successfully completing the
«Course»

Grade: «Grade»

The same certificate design can be used for multiple students.

15. Advantages of Mail Merge

Mail Merge provides several benefits:

• Saves time
• Reduces repetitive typing
• Creates personalized documents
• Reduces manual errors
• Handles large recipient lists
• Works with Excel data
• Supports letters, labels, envelopes, and emails
• Makes bulk document creation easier
• Provides consistent formatting

16. Common Mail Merge Problems

Problem 1: Wrong Information Appears

Possible reason: Incorrect data source or merge field.

Solution: Check the Excel data and inserted fields.

Problem 2: Blank Information

Possible reason: The corresponding Excel cell is empty.

Solution: Complete the missing data in the source file.

Problem 3: Wrong Recipients

Possible reason: Incorrect filtering or recipient selection.

Solution: Open Edit Recipient List and verify the selected records.

Problem 4: Formatting Changes

Possible reason: Differences between the source data and Word formatting.

Solution: Review the field formatting and preview the merged results before completing the merge.