Advanced Users may use this as a general guide. We cannot support individuals wishing to use this feature.

It is provided as-is for users wishing to generate certificates from the AD data,


Hints on general process.

  1. Download the Excel document and save to a known location (eg C:\temp)

  2. Download the Word template and save to the same location

  3. Open the template.
    You may receive the following error message:

    Click on [Yes]

  4. Find the Excel document you downloaded at step 1, and select it
    You may get the following error

    Select [Find Data Source ...]
    Select the document you downloaded at step 1 (again)

  5. When prompted, select the relevant table


  6. You should now see the template information



  7. You may alter the template to suit your needs, as required. 
    EG to change the text elements, or to move the data fields around.

  8. Click on the [Mailings] option in Word.


  9. Select [Preview Results]

    You should now see the first name from the Excel document in the template


  10. You can now print each of the certificates individually, by using the navigation buttons to scroll through the records.



Depending on your version of Word, the various buttons or menu items may be labelled differently, or have a different appearance.

These instructions are provided only as a guidance .. again we cannot support you with your endeavours to use this advanced feature.

This is provided to support advanced users who are familiar with this process.