Create a mail merge as follows:
- Link the document 7_Certificate to the Winners worksheet in the 7_Winners List spreadsheet file - NSC Computer Application Technology - Question 7 - 2017 - Paper 1
Question 7
Create a mail merge as follows:
- Link the document 7_Certificate to the Winners worksheet in the 7_Winners List spreadsheet file.
- Link the placeholders shaded in... show full transcript
Worked Solution & Example Answer:Create a mail merge as follows:
- Link the document 7_Certificate to the Winners worksheet in the 7_Winners List spreadsheet file - 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
Open the 7_Certificate document. Navigate to the mail merge feature and select the Winners worksheet from the 7_Winners List spreadsheet as the 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
Identify the yellow-shaded placeholders in the 7_Certificate document and link each one to the corresponding fields from the Winners worksheet. Ensure that all placeholders are correctly mapped.
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 to filter out anyone who is not a platinum member or does not have an adoption certificate. This can usually be done through the mail merge options, where you can set conditions based on membership status.
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
Once the mail merge setup is complete, save the 7_Certificate document to ensure all changes are preserved.
