Mail Merging
Mail merging is a way of placing content from a spreadsheet, database, or table into a word processed document.
The first step is to attach the file that contains the list of interview candidates the document just save: MarketingCandidates
Click on the button: Select Recipients, and then Use an Existing list.
You will need to navigate through your filling system to the folder with Marketing candidates.
When you have selected the file it may have initially appear as if nothing has happened, but if you look at the mailings panel you should notice that a couple of the other options such as ‘insert merge field’ have now become available. This indicates that the table in Marketing Candidates been attached and the fields can be inserted.
Delete the couple of lines that tell you where to put in the candidates name and address details.
Click on the FirstName and a marker will be placed in letter where you had left the cursor.
Repeat this procedure for: FamilyName, Street, Town, Post_Code. Remember to leave a blank space between the FirstName and FamilyName, and then place the other three on separate lines.
Now replace the text Candidate’s first name and Candidate interview time with the correct merge fields.
IGCSE ICT 