The name of the adoption certificate winners are stored in the 7_Winners List spreadsheet, in the Winners worksheet - NSC Computer Application Technology - Question 7 - 2017 - Paper 1
Question 7
The name of the adoption certificate winners are stored in the 7_Winners List spreadsheet, in the Winners worksheet.
7.1 Create a mail merge as follows:
- Link the... show full transcript
Worked Solution & Example Answer:The name of the adoption certificate winners are stored in the 7_Winners List spreadsheet, in the Winners worksheet - NSC Computer Application Technology - Question 7 - 2017 - Paper 1
Step 1
Link the document 7_Certificate to the Winners worksheet in the 7_Winners List spreadsheet file.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To link the document, open the 7_Certificate file and navigate to the mail merge settings. Select the Winners worksheet from the 7_Winners List spreadsheet as your data source.
Step 2
Link the placeholders shaded in yellow to the appropriate fields.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In the 7_Certificate document, select each placeholder shaded in yellow and use the mail merge feature to link them to their corresponding fields from the Winners worksheet. Ensure all necessary fields are correctly matched.
Step 3
Only the platinum members with an adoption certificate should receive the certificates.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Edit the recipient list in the mail merge settings to include only those members classified as Platinum and who have achieved an adoption certificate. Use any filtering options available to select the right recipients.
Step 4
Save the document 7_Certificate.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Save your changes to the 7_Certificate document to ensure that all linkages are properly stored.
