AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Digital Literacy

Build once, send many

Week 2 · Unit 8.1: Communicating with others using digital tools · 3 lessons
2

Letters that know your name

Digital Literacy 8: Unit 8.1, objectives 8TC.03, 8TC.01
GoalExplain how a master document and a list work together in a mail merge, and name the benefits and risks.
New words
master document · the main letter that holds the fixed text and the blank fieldsmail merge · joining one master document with a list to make a personal copy for each persondata list · a table of names and other details, one row for each personmerge field · a blank in the master document that takes its words from the list
Explanation

Imagine writing 200 letters, each with a different name. A mail merge does the work in one go. You write one master document with the fixed text and put merge fields where the personal parts go, such as [first name] and [group]. You also make a data list, a table with one row for each person. The word processor joins them: for row one it fills the fields with the words from row one, for row two with row two, and so on. You get a personal letter for each person without typing 200 times. The benefits are speed and accuracy. The risks are mistakes in the list, which appear in the letters, and the privacy of the list. A list of names should be kept safe and shared only with people who need it.

Worked examples
ABC
1first namegroupday
2AnaRocketsTue
3KenjiPlantsWed
4MiaRocketsTue
The invented Hilltop Science Club writes one master letter. The merge fields are shown in square brackets. The data list is below it.
Letter

Dear Kenji, your Plants group meets on Wed in the school lab. Please bring a notebook.

The second person on the list, Kenji, gets this letter. Notice that the master document did not change; only the fields were filled.
ABC
1first namegroupday
2AnaRocketsTue
3LeoRocketsThu
A mistake in the list becomes a mistake in the letter. Here the list has the wrong day for one row. Always check one or two test letters against the list before printing them all.
Class activity

Hand-made merge (on paper, no computer). Write a short master letter for an invited school event. Put two merge fields in square brackets, such as [name] and [time]. Make a data list of four invented first names with times. Swap with a partner. Your partner writes the four letters by hand, filling in the fields. Check each letter against the list and find one deliberate mistake the original writer hid in the list. Then say what a person must check before sending a real merge. If you have a computer or tablet, try a mail merge with your invented list.

Practice
1
The master letter says: ‘Dear [name], your [group] group begins at [time] on [day].’ Look at the list and write the letter for the second person on the list.
ABCD
1namegrouptimeday
2YukiPainters2 pmFriday
3OmarBakers3 pmMonday
2
A school sends a merge letter to 120 families, but the list has a family’s name spelled wrongly. Who notices and what can the school do?
3
Give one reason the data list for a mail merge needs to be kept private.
4
Which is the master document and which is the data list?
A

Dear [first name], please bring [item] on [day].

B

Mina – pencil – Monday | Ravi – ruler – Tuesday