Tip sheets | Glossary | Home | Contents

 

Mail merge a letter

 

Level of difficulty: Advanced

As an educator or administrator, you may need to send letters to a large number of persons, where most of the content is the same, but some items (such as names and addresses) are unique to each recipient.  For example, you can send letters to award recipients, where the congratulation is the same for everyone, but each recipient has a unique name and receives a different award.  You will use Microsoft Word to mail merge a letter.

Click here for example

If you have not used Microsoft Word before, consider completing this scenario first.

 

Merge your own letter - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps:

 
Description
Resources
1 Start Microsoft Word How to start Microsoft Word
2 Data table - Insert a table: In a new document type the data that is unique to each letter - use a table

How to insert a table
Example of data letter

3 Save the data table How to save a file
4 Open the Mail Merge Wizard: You will use a "wizard" that will take you step by step through the process. How to use the mail merge wizard
5 Link to a data table: In step 2 of the wizard you will use the data table that you have created in task 2 above. How to link to a data table
6 Write a letter, merging the data: In step 3 of the wizard you will type the basic letter and insert the unique fields from the data table. How to merge data in a letter
7 Spell check the merged letter: It is wise to spell check before saving and printing a document How to conduct a spell check
8 Save the merged letter How to save a file
9 Print the merged letters How to print a file
10 Exit Microsoft Word How to exit Microsoft Word
 

Related scenarios

Write a bulletin to parents

Write a good news note (and include mailmerge fields)

Create a class database, from which you read data for the mail merged letter

Home | Contents