Microsoft Word
The purpose of the MS Word is to allow the users to type and save documents. Similar to other word processors, it has helpful tools to make documents.
Mail Merge
Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet.
1. Launch Microsoft Word
2. Prepare/type full certificate as shown in the image below.
3. On the Menu bar, click Mailings, click Start Mail Merge.
4. Choose Step by Step Mail Merge Wizard.
5. On the Select document type, choose Letters and click Next:Starting Document.
6. Click on Use the current document.
7. Click Next:Select recepients
8. Go to type a New List and click Create. The New Address List dialog box will appear.
9. Choose customize column and in the Field Names, select and click delete on the unnnecessary item except First Name, Last Name and add IC No. Click OK.
10. Insert all the details of certificate receivers.
11. Click Select All to place all the record onto the certificate that has been edited. Click OK. Click Next, Write Your Letter.
12. Choose Address Block. Insert Address Box will appear.
13. Click OK and this {{AddressBlock}} will appear at the correct position on the certificate.
14. Click More Items to add IC.No on the certificate. {{IC No}} will appear at the correct position on the certificate.
15. Click Next, Preview Your Letters for the next step. Name and IC No. of the certificate receivers will appear.
16. Now you can see all the edited certificate for the next receiver. You just need to push Next Button. Click Next, Complete The Merge if the process is already done.
17. You have already completed the Mail Merge.
ThankYou ! 🎈
The purpose of the MS Word is to allow the users to type and save documents. Similar to other word processors, it has helpful tools to make documents.
Mail Merge
Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet.
1. Launch Microsoft Word
2. Prepare/type full certificate as shown in the image below.
3. On the Menu bar, click Mailings, click Start Mail Merge.
4. Choose Step by Step Mail Merge Wizard.
5. On the Select document type, choose Letters and click Next:Starting Document.
6. Click on Use the current document.
7. Click Next:Select recepients
8. Go to type a New List and click Create. The New Address List dialog box will appear.
9. Choose customize column and in the Field Names, select and click delete on the unnnecessary item except First Name, Last Name and add IC No. Click OK.
10. Insert all the details of certificate receivers.
11. Click Select All to place all the record onto the certificate that has been edited. Click OK. Click Next, Write Your Letter.
12. Choose Address Block. Insert Address Box will appear.
13. Click OK and this {{AddressBlock}} will appear at the correct position on the certificate.
14. Click More Items to add IC.No on the certificate. {{IC No}} will appear at the correct position on the certificate.
15. Click Next, Preview Your Letters for the next step. Name and IC No. of the certificate receivers will appear.
16. Now you can see all the edited certificate for the next receiver. You just need to push Next Button. Click Next, Complete The Merge if the process is already done.
17. You have already completed the Mail Merge.
ThankYou ! 🎈
