Lesson Notes By Weeks and Term v5 - Grade 12

Lesson Video

This page supports the lesson note with a companion video and a short classroom-ready summary.

For class groups and homework, share this lesson page so learners also get the summary, objectives, and full lesson context.

Performance objectives

• Create a main document with placeholders (merge fields).
• Connect the main document to a data source like a spreadsheet.
• Insert and format merge fields correctly.
• Perform a mail merge to generate letters, emails, or labels.
• Filter and sort data to target specific recipients.

Lesson summary

Integrated documents and mail merge are essential skills for efficient communication and data management, particularly in a business or organizational context. Imagine a local community organization needing to send personalized letters to hundreds of residents informing them about an upcoming community clean-up event or a small business advertising a promotion to its customers. Manually creating each letter would be incredibly time-consuming and prone to errors. Mail merge provides a solution by automating this process, linking a single document (the main document) to a data source (e.g., a spreadsheet or database) containing the personalized information.

Lesson notes

2.1 Understanding Integrated Documents and Mail Merge Mail merge is a powerful tool for creating personalized documents by combining a main document with data from a separate data source. The main document contains the static text and formatting that will be consistent across all documents, while the data source holds the personalized information that will vary for each recipient.

Components of a Mail Merge: Main Document: This is the template document containing the standard text and formatting. It also includes placeholders, called merge fields, which are replaced with data from the data source during the merge process. Think of it as the blueprint for your letter, email, or label.

Data Source: This is the file containing the data that will be inserted into the main document. Common data source formats include spreadsheets (e.g., .xlsx or .csv files) and databases (e.g., .accdb files). Each row in the data source represents a record, and each column represents a field (e.g., name, address, contact number). Consider this as the address book you are using.

Merge Fields: These are placeholders in the main document that indicate where data from the data source should be inserted. They are typically represented by names enclosed in special characters (e.g., ` >`, ` >`). The word processor recognizes these and replaces them with the correct information.

Merged Document: This is the final output of the mail merge process, consisting of multiple personalized documents created by combining the main document with data from the data source. It's the complete set of letters, labels, or emails. 2.2 Steps Involved in a Mail Merge: Create the Data Source: Determine the information you need to personalize and create a data source (e.g., a spreadsheet) with appropriate fields (columns) and records (rows).

Create the Main Document: Open a word processor and create the main document. Type the standard text and format it as desired.

Link the Data Source: Connect the main document to the data source. The word processor will prompt you to select the file containing the data.

Insert Merge Fields: Insert merge fields into the main document at the locations where you want to insert personalized information. The word processor provides a tool for easily selecting and inserting merge fields.

Preview the Merge: Preview the merged documents to ensure that the data is being inserted correctly and that the formatting is as expected.

Perform the Merge: Execute the mail merge to generate the final merged documents. You can choose to print the documents directly, save them to a file, or send them as emails.

Filter and Sort: Before performing the merge, you can filter the data source to include only specific records or sort the data to organize the documents in a particular order. 2.3 Worked Examples Example 1: Creating Personalized Letters for a School Fundraiser A school in Soweto, Gauteng wants to send personalized letters to parents and guardians, requesting donations for a new computer lab.

Data Source: An Excel spreadsheet named "ParentData.xlsx" with the following columns: `FirstName`, `LastName`, `Address`, `City`, `PostalCode`, `DonationGoal`.

Main Document: A Word document with the following structure: ``` [School Letterhead] > > > >, > Dear >, We are writing to you today to request your support for our school's fundraising campaign to build a new computer lab. ... (Rest of the letter) ... We are hoping you will consider a donation of >. Sincerely, [School Principal's Name] ``` Steps: Data Source: Ensure the "ParentData.xlsx" file exists and contains the necessary data.

Main Document: Create the Word document and type the letter content as shown above.

Link Data Source: In Word, go to Mailings > Start Mail Merge > Letters. Then, select Recipients > Use an Existing List and choose "ParentData.xlsx".

Insert Merge Fields: Place the cursor where you want to insert a merge field (e.g., after "Dear ") and go to Mailings > Insert Merge Field and select the appropriate field (e.g., "FirstName"). Repeat for all other fields.

Preview Results: Click on Mailings > Preview Results to see how the merged letters will look.

Finish & Merge: Click on Mailings > Finish & Merge > Edit Individual Documents to create a new document with all the personalized letters.

Example 2: Creating Email Labels for a Small Business Promotion A small bakery in Durban, KwaZulu-Natal, wants to send promotional flyers to potential customers.

Data Source: A CSV file named "CustomerList.csv" with the following columns: `CustomerID`, `Name`, `EmailAddress`.

Main Document: In Word, you would typically use the Labels feature in Mail Merge.

Steps: Data Source: Make sure the "CustomerList.csv" file is prepared.

Main Document: In Word, go to Mailings > Start Mail Merge > Labels. Choose the appropriate label size.

Link Data Source: Select Recipients > Use an Existing List and choose "CustomerList.csv".