Using Mail Merge | Grade IX

1. Learning Objectives

By the end of this lesson, students should be able to:

Explain the meaning and purpose of mail merge.
Identify the main components of a mail merge operation.
Explain the difference between a main document and a data source.
Create or select a recipient list.
Insert merge fields into a document.
Preview personalised documents before completing the merge.
Generate personalised letters, invitations and labels.
Understand how mail merge saves time and reduces repetitive typing.

2. What is Mail Merge?

Mail Merge is a feature of LibreOffice Writer that combines a common document with a list of recipient information to create multiple personalised documents.

Instead of creating each letter separately, we prepare one main document and connect it to a data source containing information such as names and addresses.

Main Document

Data Source

→

Mail Merge

→

Personalised Documents

3. Why Use Mail Merge?

⏱️ Saves Time

A single document can be used to create many personalised copies.

⌨️ Reduces Typing

Names and addresses do not need to be entered repeatedly.

🎯 Personalisation

Each recipient can receive a document containing their own information.

✅ Accuracy

Reusing a common document reduces repeated manual editing.

📄 Consistency

All generated documents can use the same formatting and message.

📬 Bulk Communication

Useful for communicating with many recipients at once.

4. Examples of Mail Merge

Personalised invitation letters.
School circulars addressed to individual parents.
Certificates containing different student names.
Business letters sent to multiple clients.
Address labels.
Envelopes containing recipient addresses.
Notices generated for a large group of recipients.

Example: A school needs to send the same invitation to 100 parents. Instead of typing 100 letters, the school can prepare one invitation and use the parent database as the data source.

5. Components of Mail Merge

A mail merge operation mainly involves the following components:

Component	Meaning
Main Document	The document containing the common text, formatting and merge fields.
Data Source	The source containing recipient information such as names and addresses.
Fields / Merge Fields	Placeholders in the main document that are replaced with information from the data source.
Recipients	The people or organisations who receive the generated documents.
Merged Documents	The personalised documents produced after the merge.

6. Main Document

The main document contains the common content that will appear in every merged document.

For example, an invitation may contain the same event date, venue and message for every recipient.

Dear <First_Name>,

You are cordially invited to attend our Annual Science Exhibition.

Date: 20 September 2026
Venue: School Auditorium

We look forward to your presence.

Regards,
School Administration

In this example, most of the text is common to all recipients, while <First_Name> is a merge field.

7. Data Source

A data source contains the information that changes from one recipient to another.

A data source can contain fields such as:

First Name
Last Name
Address
City
State
PIN Code
Email Address
Organisation

8. Example of a Recipient List

First Name	Last Name	City	PIN
Aarav	Sharma	Greater Noida	201310
Diya	Verma	Ghaziabad	201001
Rohan	Singh	Delhi	110001
Ananya	Gupta	Noida	201301

The rows represent individual records, while the columns represent fields.

9. Field and Record

Field

A field is a category of information stored in the data source.

Example: First Name, City, PIN Code.

Record

A record contains the information relating to one recipient.

Example: all details belonging to Aarav Sharma form one recipient record.

10. Merge Fields

A merge field is a placeholder inserted into the main document. During the merge, it is replaced by the corresponding value from the selected recipient record.

Examples

Merge Field	Data Source Value	Result
<First_Name>	Aarav	Aarav
<City>	Delhi	Delhi
<PIN>	110001	110001

11. Mail Merge Workflow

Prepare Data

→

Create Main Document

→

Insert Fields

→

Preview

→

Merge

→

Print / Save

12. Step 1 — Prepare the Data Source

Before starting the merge, prepare an accurate recipient list.

Guidelines

Use meaningful field names.
Enter one recipient per record.
Check spelling of names.
Check addresses and PIN codes.
Avoid unnecessary blank records.
Keep the data consistent.
Save the data source appropriately.

Incorrect data in the recipient list will result in incorrect personalised documents. Always verify the data before completing the merge.

13. Step 2 — Create the Main Document

Open LibreOffice Writer.
Create a new document.
Type the common content.
Format the document appropriately.
Leave suitable positions for recipient-specific information.

For a letter, the recipient's name and address are likely to be different for each record, while the body of the letter remains common.

14. Step 3 — Insert Merge Fields

Merge fields are inserted at the locations where recipient-specific information should appear.

Example

Dear <First_Name> <Last_Name>,

We are pleased to invite you to our school event.

Your city: <City>

During the merge, the fields are replaced with the appropriate values from each recipient's record.

15. Step 4 — Select Recipients

A mail merge may use all records in the data source or a selected subset of recipients.

Examples

All parents of Class IX.
Only parents from a particular section.
Only customers from a specific city.
Only selected clients.

Important: Selecting recipients carefully prevents unwanted documents from being generated.

16. Step 5 — Preview the Merged Documents

Previewing allows you to verify that the merge fields are receiving the correct data.

Check:

Names are correct.
Addresses appear in the correct positions.
There are no blank or incorrect fields.
Formatting is consistent.
Page layout is correct.
No unnecessary blank pages are generated.

17. Step 6 — Complete the Merge

Once the preview has been checked, the merge can be completed. Depending on the requirement, the resulting documents can be printed or saved.

🖨️ Print

Send the merged documents directly to a printer.

💾 Save

Generate merged documents for further editing or electronic use where appropriate.

18. Mail Merge Wizard

LibreOffice Writer provides a Mail Merge Wizard that guides users through the major steps of creating a mail merge.

The wizard can help configure the document, address block, recipient list, layout and final output.

Typical Workflow

Choose the document type.
Choose or create the address list.
Configure recipient information.
Arrange fields in the document.
Preview the results.
Complete the merge.

19. Creating a New Recipient List

If a suitable data source does not already exist, a new recipient list can be created.

General Procedure

Start the mail merge process.
Choose the option to create a new address or recipient list.
Enter the required recipient details.
Add additional records as required.
Review the information.
Save the recipient list.

Example: If a company has five new clients, their contact details can be added to the recipient list used by the mail merge.

20. Editing the Recipient List

Recipient information may change over time. Records can be updated when necessary.

Add new recipients.
Edit incorrect names.
Correct addresses.
Remove recipients who should not receive the document.
Review the final list before merging.

21. Selecting and Filtering Recipients

When a data source contains many records, it may be useful to select only the required recipients.

Example: A school has a database containing 500 students, but a notice is required only for Class IX students. The recipient records should be restricted to the appropriate students or parents.

22. Creating Personalised Letters

ABC SCHOOL

Date: 10 September 2026

To,
<First_Name> <Last_Name>
<Address>
<City>

Subject: Invitation to Science Exhibition

Dear <First_Name>,

We are pleased to invite you to our annual Science Exhibition. We would be delighted by your presence.

Regards,
Principal

The same template can generate personalised letters for many recipients.

23. Creating Address Labels

Mail merge can also be used to generate labels containing different recipient addresses.

Applications

Postal addresses.
Product labels.
Event badges.
Student identification labels.
Business mailing labels.

24. Creating Personalised Certificates

Mail merge can generate certificates with a different name while keeping the certificate design and wording the same.

This certificate is awarded to

<Student_Name>

for outstanding participation in the Science Exhibition.

25. Main Document vs. Data Source

Main Document	Data Source
Contains common content.	Contains recipient-specific information.
Usually remains the same for all recipients.	Values change from one record to another.
Contains merge fields.	Contains the values that populate those fields.
Example: invitation letter.	Example: recipient name and address list.

26. Field vs. Record

Field	Record
A category of information.	Complete information about one recipient.
Example: First Name.	Example: Aarav Sharma, Delhi, 110001.
Forms a column in a table-like data source.	Forms a row in a table-like data source.

27. Practical Activity: Personalised Invitation 💻

Task

Create a personalised invitation letter for five recipients using LibreOffice Writer's mail merge feature.

Recipient List

Create fields for:

First Name
Last Name
Address
City
PIN Code

Procedure

Create a new Writer document.
Prepare the invitation text.
Create or select the recipient list.
Insert the recipient name and address fields.
Preview the personalised documents.
Correct any errors.
Complete the merge.
Save the resulting document or print it as instructed.

28. Case Study: School Invitation

A school wants to invite 200 parents to its Annual Day. The invitation text, date, time and venue are the same for everyone, but each letter must contain the parent's name and address.

Solution

Create one main invitation document.
Prepare a recipient list containing parent details.
Insert fields such as Parent Name and Address.
Preview several records.
Complete the mail merge.
Print or save the personalised invitations.

This is much more efficient than manually preparing 200 separate documents.

29. Competency-Based Questions

Question 1

Swati wants to prepare personalised invitations for 100 guests without typing each guest's name and address again and again. Which feature should she use?

Answer: She should use the Mail Merge feature in LibreOffice Writer.

Question 2

Radhika wants to send a personal invitation to several people. What advantage does mail merge provide?

Answer: It allows her to prepare one common invitation and automatically insert each recipient's personal information from a data source.

Question 3

Suchitra is an office assistant. Her company has five new clients. Where should she enter their contact details when using mail merge?

Answer: She should add their contact details as new records in the recipient list/data source.

Question 4

A school has a list containing 500 parents, but a notice must be sent only to Class IX parents. What should be done?

Answer: The appropriate recipient records should be selected or filtered before completing the merge.

Question 5

A mail merge document displays the wrong name for one recipient. What should be checked first?

Answer: Check the corresponding record in the data source and verify that the correct merge field is being used.

30. Common Mail Merge Errors

Problem	Possible Cause	Solution
Wrong name appears	Incorrect data record or field.	Check the recipient record and merge field.
Blank merge field	Required data is missing.	Complete the corresponding data source field.
Wrong recipients selected	Recipient selection was not checked.	Review the recipient list before merging.
Formatting looks incorrect	Field placement or document formatting is unsuitable.	Review the main document and preview the merge.
Missing address	Address field is empty or the wrong field was inserted.	Check the data source and inserted field.

31. Good Practices for Mail Merge

Use clear and meaningful field names.
Check the recipient list before starting the merge.
Keep names and addresses consistently formatted.
Use the correct merge fields.
Preview multiple recipient records.
Proofread the main document.
Check the recipient selection.
Test the merge with a small number of records when appropriate.
Protect sensitive recipient information.
Save the required files after completing the merge.

32. Privacy and Responsible Use 🔐

A mail merge may involve personal information such as names, addresses, telephone numbers or email addresses. Such data should be handled responsibly.

Use recipient data only for an appropriate purpose.
Do not share personal data unnecessarily.
Store recipient lists securely.
Check recipients carefully before sending documents.
Do not accidentally send one person's private information to another recipient.

33. Mail Merge vs. Manual Copy-Paste

Manual Method	Mail Merge
Each document is edited separately.	One main document is connected to a data source.
Requires repeated typing.	Recipient-specific data is inserted automatically.
More time-consuming for large lists.	Efficient for large recipient lists.
Higher risk of inconsistent formatting.	Common formatting can be maintained.

34. Quick Example

Main Document:

Dear <Name>,

You are invited to the Annual Day celebration at <Venue>.

Name	Venue
Aarav	School Auditorium
Diya	School Auditorium

Result:

Dear Aarav, You are invited to the Annual Day celebration at School Auditorium.

Dear Diya, You are invited to the Annual Day celebration at School Auditorium.

35. Think About It 🤔

Why is mail merge useful when communicating with many people?
What is the difference between a main document and a data source?
What is a merge field?
What is a record?
What is a field?
Why should the recipient list be checked before completing a merge?
Why is previewing important in mail merge?
How can mail merge reduce repetitive work?
Give three real-life applications of mail merge.
Why should personal information in a recipient list be protected?

36. Key Terms

Term	Meaning
Mail Merge	A feature used to create multiple personalised documents from a common document and a data source.
Main Document	The common document containing fixed content and merge fields.
Data Source	A source containing recipient-specific information.
Recipient List	A collection of records containing information about people or organisations receiving the documents.
Field	A category of information in a data source.
Record	A complete set of information about one recipient.
Merge Field	A placeholder in the main document that is replaced by data from the recipient record.
Preview	The process of checking how personalised documents will appear before completing the merge.

37. Lesson Recap

Mail Merge is used to create multiple personalised documents efficiently.
The main document contains the common text and merge fields.
The data source contains recipient-specific information.
A field represents a category of information, while a record represents one complete recipient entry.
Merge fields act as placeholders for recipient information.
A recipient list can be created, edited, selected and filtered as required.
Mail Merge Wizard can guide users through the mail merge process.
Always preview merged documents before printing or distributing them.
Mail merge can be used for letters, invitations, certificates, labels and other personalised documents.
Recipient information should always be handled responsibly and securely.

38. Homework 📝

Define mail merge.
Explain the purpose of the main document in mail merge.
What is a data source?
Differentiate between a field and a record.
What is a merge field?
Write the basic steps involved in a mail merge operation.
What is a recipient list?
How can a new recipient list be created?
Why is previewing important before completing a mail merge?
Give four practical applications of mail merge.

39. Quick Assessment

What is mail merge?
What is a main document?
What is a data source?
What is a merge field?
What is a record?
What is a field?
Why is a recipient list required?
What is the role of the Mail Merge Wizard?
Why should merged documents be previewed?
Name any three applications of mail merge.