This guide explains how to import names onto certificates using the mail merge feature in Microsoft Word.
1) If the certificate is a PDF file, open it using the Pro Version of Adobe Reader, if Adobe Reader isn't your default program for opening PDF files you can do this by right clicking on the file and select Open with > Adobe Acrobat:
2) The file will then open in Adobe Reader, press the convert button in the top left:
3) Leave the option selected as Microsoft Word and press 'Convert to DOCX':
4) You'll then be asked to choose somewhere to save the file, select the folder that you would like to save it in and then press save:
5) The file will then open in Microsoft Word, now you want to select Insert > Text Box > Simple Text Box:
6) With the text box selected select Shape Format > Wrap Text > In Front of Text:
7) Under the shape format area select > Shape Outline > No Outline:
8) Drag the text box to where you want the students' names to be displayed, then select all of the text inside the text box and press the backspace key on your keyboard to delete all of the text so it's empty.
9) Then go to the Mailings tab at the top > Start Mail Merge > Letters
10) Under the Mailings tab select Select Recipients > Use an Existing List:
11) You'll then be asked to select the data source, go to the folder where the Excel file containing the students names is saved and then press Open
12) You'll then be asked to select the table, press OK:
13) Select the text box and then under the Mailings tab select Insert Merge Field > Name:
14) Change the font and text size to any of your choosing:
15) Under the Mailings tab select Finish & Merge > Edit Individual Documents:
16) Leave the option selected as All and press OK:
17) A new Word Document window will open will all of the certificates with the students names inserted into them. 😎
If you have any issues or questions whilst following this process please contact the IT Helpdesk and we'll be happy to help. 😊
