9626_m18_qp_32
A paper of Information Technology, 9626
Questions:
12
Year:
2018
Paper:
3
Variant:
2

Login to start this paper & get access to powerful tools

3
4
5
A global company has many managers in cities around the world. A mail merge document is being created to invite each manager to a training event. The section of the data source file storing the managers’ details for the mail merge is: Invite? Title First Name Family Name Address1 Address2 City Country Postcode Yes Mr Harold Johnson The Beeches 12a Bury St Manchester UK M3 4EN Yes Mr Ahmed Molokya El Gezira St Dokki Cairo Egypt Yes Ms Rowena Cobb PO Box Sunshine Drive Auckland New Zealand Yes Mr Vihann Sardana SM Mandir Mumbai India No Mr Sam Wick 4 The Avenue Attwood Hume Australia Yes Mrs Rethebile Pillay Farnworth Cape Town South Africa Yes Miss Charlene Foster 15 Stirling Highway Melbourne Terrace Melbourne Australia No Mr Daniel Cross 64 Cherry Rd Hinton Cambridge UK CB1 4EF Managers in the UK and Egypt will be invited to the event in London while all others will be invited to the event in Hong Kong. Managers who are not being invited are marked as ‘No’ in the source file. A first draft of the mail merge template for the letter is shown here: > > > > > > > Dear > > The company is holding a training event for you on 1 July 2019 in > and you are invited to attend. All expenses for travel from your home city of > and accommodation at the meeting will be paid by the company. Yours sincerely Managing Director Explain how the mail merge may be set up to create letters only to those who are invited. Explain how the mail merge template, shown on page 8, must be altered to ensure that the managers who receive an invitation are asked to the correct event.
6