
MALABAR SECONDARY SCHOOL

MAIL MERGE

The mail merge feature, allows you to produce large volumes of personalised letters, mailing labels, memos and emails without having to type each one individually for each recipient.
For example, many companies send standard letters to customers in which the body of the letter is the same, but the name, address and a few other pieces of information may be different. This type of multi-recipient correspondence can be produced easily using mail merge.
Merging requires the use of two files:
1. The main document (primary file)
A Main Document or Form letter that contains the text and graphics that are the same for each letter. The main document must contain merge fields or placeholders into which recipient information will be inserted. Some examples of merged fields are <<First_Name>>, <<Surname>>, <<Company Name>>, <<Address1>> etc.
2. A data source (secondary file)
A Data source file contains the information to be merged or placed into the main document. This is usually a table containing the list of recipients’ names and addresses. The heading of each column is the same as the name of the merge fields, example Surname or Company Name.
Data from the data source is inserted
The diagram below shows the Mail Merge Process

Taken from Log on to IT by Roland Birbal & Michelle Taylor

Click the button below for your quiz on Mail Merge

Now let's do a Practical Task using Mail Merge
Mrs Thomas runs a Technical Institute. Help her prepare 25 certificates for her students who completed all their courses.
Download the following documents and save on your desktop using the following:
1. Your name Main Doc
2. Your name Source Doc
Main Document
Source File
Use the following guidelines to help you complete your mail merge.
