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.
• Prepare a data source like a spreadsheet.
• Perform a mail merge to generate personalized documents.
• Filter and sort data for targeted mailings.
• Troubleshoot common mail merge errors.

Lesson summary

This week, we delve into the power of integrated documents and mail merge, a crucial skill for creating professional and personalised communications efficiently. Imagine needing to send out invitations to the matric farewell, personalized letters to potential sponsors for a school event, or even creating address labels for delivering textbooks. Manually creating each document would be time-consuming and prone to errors. Mail merge allows us to automate this process, linking a master document with a data source to generate multiple personalized documents. This is incredibly valuable in various professional settings, from marketing and administration to project management.

Lesson notes

2. 1. What is Mail Merge? Mail merge is a powerful feature available in word processing applications (like Microsoft Word or LibreOffice Writer) that allows you to create personalized documents from a single template and a data source. Essentially, it merges data from a list (e.g., names, addresses, greetings) into a main document to produce multiple unique documents. 2.

2. Components of Mail Merge: Main Document: This is the template document containing the text and formatting that will be the same for all merged documents. It includes placeholders (called merge fields) that indicate where the personalized data from the data source should be inserted.

Example: A letter template with placeholders for name, address, and greeting.

Data Source: This is a file (e.g., a spreadsheet, database table, or even a text file) that contains the personalized information for each recipient. The data is organized into columns (fields) and rows (records).

Example: A spreadsheet with columns for FirstName, LastName, Address, City, PostalCode, and Greeting.

Merge Fields: These are placeholders in the main document that represent the column headings in the data source. The merge fields are replaced with the corresponding data from each record during the mail merge process.

Example: ` >`, ` >`, ` >`.

Merged Document: The final product. It is a collection of documents, each personalized with data from a specific record in the data source. 2.

3. Steps in the Mail Merge Process: Create the Data Source: Decide what information you need to personalize your documents and create a data source containing this information. Use a spreadsheet program (like Excel or Google Sheets) or a database program (like Access or LibreOffice Base). Ensure the first row contains the column headings (field names). Pay careful attention to data types (e.g., numbers, text, dates) and ensure consistency.

Example: A spreadsheet for sending invitations to a school fundraising gala might include columns for Title (Mr., Ms., Dr.), FirstName, LastName, Address, City, PostalCode, and DonationLevel.

Create the Main Document: Open a word processor and create the main document (e.g., a letter, invitation, envelope). Type the text that will be the same for all documents.

Insert Merge Fields: In the main document, insert merge fields at the locations where you want to insert personalized data. The exact procedure for inserting merge fields will vary depending on the word processor you are using, but generally, you will find it under the "Mailings" or "Tools" menu.

Example: In Microsoft Word, go to Mailings > Insert Merge Field and select the appropriate field from the list.

Connect the Data Source: Connect the main document to the data source. This tells the word processor where to retrieve the personalized data.

Preview and Merge: Preview the merged documents to ensure that the data is being inserted correctly and that the formatting is as desired. Make any necessary adjustments. Once you are satisfied, perform the mail merge to generate the final documents. You can choose to merge directly to a printer, to a new document, or to individual files.

Filtering and Sorting: Before merging, you might want to filter your data. For example, you might only want to send invitations to people in a specific city, or to donors who have donated a certain amount. You can also sort your data, for example, alphabetically by last name. 2.

4. Worked Examples (South African Context): Example 1: Sending Matric Farewell Invitations: Data Source: Create a spreadsheet with columns like Title, FirstName, LastName, Address, GuardianName.

Main Document: Create an invitation template with merge fields for ` >`, ` >`, ` >`, ` >`, ` >`. The main body of the invitation will contain standard text about the farewell.

Merge: Connect the data source to the main document, preview, and merge to create personalized invitations for each student, addressed to them and their guardians.

Example 2: Sending Thank You Letters to Sponsors: Data Source: Create a spreadsheet with columns like CompanyName, ContactPerson, Address, DonationAmount, DonationDate.

Main Document: Create a thank you letter template with merge fields for ` >`, ` >`, ` >`, ` >`, ` >`. The letter should express gratitude for their support.

Merge: Connect the data source to the main document, preview, and merge to create personalized thank you letters for each sponsor.

Example 3: Creating Address Labels for Textbook Distribution: Data Source: Create a spreadsheet with columns like FirstName, LastName, StreetAddress, Suburb, City, PostalCode.

Main Document: Select the appropriate label layout within your word processor. Insert merge fields for ` >`, ` >`, ` >`, ` >`, ` >`, ` >` into the label template.

Merge: Connect the data source to the main document, preview, and merge to create a sheet of address labels for textbook distribution. 2.5.