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

• Define the purpose of mail merge.
• Create a suitable data source.
• Create and link a main document.
• Insert merge fields correctly.
• Perform a mail merge to generate documents.

Lesson summary

Mail merge is a powerful feature in word processing software that allows you to create personalized documents for multiple recipients using a single template and a data source. Think about the huge volume of personalized letters and emails you see every day – from bank statements to promotional offers. Mail merge is the engine that drives this efficiency. In a South African context, imagine sending out personalized invitations to a community event, or generating individual progress reports for learners at a school – mail merge makes these tasks manageable. Mastering mail merge is a valuable skill for any job that involves communication and data management.

Lesson notes

Mail merge involves integrating two main components: Main Document: This is the template document containing the text and formatting that will be the same for all recipients. It also includes placeholders called "merge fields" where personalized information will be inserted.

Example: A standard letter inviting people to a fundraising gala.

Data Source: This is a file (e.g., a spreadsheet, database, or text file) containing the data that will be used to personalize the main document. Each row in the data source represents a different recipient, and each column represents a different piece of information (e.g., name, address, contact details).

Example: An Excel spreadsheet with columns for "FirstName", "LastName", "Address", "City", "PostalCode", "Email".

Steps in Mail Merge: Prepare the Data Source: Ensure your data is clean, accurate, and properly formatted. Each column should have a clear heading (field name). Avoid inconsistent capitalization or abbreviations. Using Excel, this means ensuring each column has a header row (e.g., FirstName, LastName, Address). Empty cells are fine, but inconsistent data types within a column (e.g., mixing numbers and text in a phone number column) will cause problems.

Example Data Source (Excel): | FirstName | LastName | Address | City | PostalCode | | --------- | -------- | --------------------------- | -------- | ---------- | | Thando | Nkosi | 123 Acacia Avenue | Durban | 4001 | | Aisha | Patel | 456 Protea Road | Cape Town| 8001 | | Sipho | Dlamini | 789 Jacaranda Street | Pretoria | 0002 | | Lerato | Mokoena | 101 Rosebank Drive | Joburg | 2196 | Create the Main Document: Open a new or existing document in your word processor (e.g., Microsoft Word, LibreOffice Writer). This document contains the static text of your letter or email.

Example Main Document (Microsoft Word): ``` [Date] [FirstName] [LastName] [Address] [City], [PostalCode] Dear [FirstName], We are pleased to invite you to our annual fundraising gala on [Date of Gala] at [Time of Gala] at [Venue of Gala]. ... (rest of the letter) Sincerely, [Your Name] ``` Note the square brackets `[]`. These are just placeholders to indicate where the merge fields will be inserted. The actual insertion is done in the next steps using the mail merge wizard/tools of your word processor.

Link the Data Source to the Main Document: In your word processor, initiate the mail merge process (usually found under "Mailings" or "Tools"). Select the data source file you prepared in Step

1. The word processor will then read the field names (column headings) from your data source.

Insert Merge Fields: Replace the placeholders in your main document with the actual merge fields from your data source. Your word processor provides tools (usually a panel or ribbon) to select and insert these fields. It's critical to insert the correct fields in the right places. Ensure there are spaces or punctuation marks where needed between fields. For instance, between `[FirstName]` and `[LastName]` you need a space.

Example (Microsoft Word): Go to Mailings > Insert Merge Field and select "FirstName". Repeat for "LastName", "Address", "City", and "PostalCode", placing them appropriately in the document. You'll now see ` > >` instead of `[FirstName] [LastName]`. These are the actual merge field codes.

Preview and Test: Before completing the mail merge, preview the results to ensure the data is being inserted correctly. This allows you to catch any errors in formatting, spacing, or data mapping. Your word processor usually provides a "Preview Results" button.

Complete the Mail Merge: Once you're satisfied with the preview, complete the mail merge.

You can choose to: Merge to a new document: This creates a separate document for each recipient.

Merge directly to the printer: This prints the personalized documents directly.

Merge to email: This sends personalized emails to each recipient (if your data source includes email addresses). This usually involves configuring your email client within the word processor.

Worked example

Example 1: Creating Mailing Labels

Scenario: A local NGO wants to send holiday greetings to its donors. They have a list of donor names and addresses in an Excel spreadsheet.

Steps:

Data Source: The Excel spreadsheet contains columns: `Title`, `FirstName`, `LastName`, `Address`, `City`, `PostalCode`. Ensure these are accurate.

Main Document: Create a new document in Word. Go to Mailings > Start Mail Merge > Labels. Select the appropriate label size and type (e.g., Avery L7160).

Link Data Source: Select the Excel spreadsheet as the data source.

Insert Merge Fields: In the first label on the sheet, insert the following merge fields, with appropriate spacing and line breaks:

```

> > >

>

>, >

```

Update Labels: Click "Update Labels" in the Mailings tab. This will copy the merge fields to all the other labels on the sheet.

Preview and Finish: Preview the labels and then click "Finish & Merge" to print or create a new document.

Example 2: Sending Personalized Emails