Spreadsheet to Create Multiple Certificates from the Whole School

At the end of every half term, I send this spreadsheet to all Heads of Department for them to nominate students in each year group who have worked particularly well and deserve recognition. The mail merge automatically creates personalised certificates with a different picture for each subject.

Instructions

1. Edit the names of the heads of year and heads of department on the right hand side of the spreadsheet.

2. Send this spreadsheet to all Heads of Department for them to fill in the names of students in each year group who have worked particularly well and deserve recognition.

3. Once the spreadsheet is complete, edit the four certificates using the mail merge wizard – when you open each of them, there will be an error message because it can’t find the spreadsheet and you’ll have to redirect it to the correct (completed) spreadsheet.

4. Save picture files for each calling them “subject name”.jpg (e.g. Art.jpg, Biology.jpg etc.) in the same folder as the certificates and the spreadsheet and it should automatically insert them on the certificates (the size needs to be more or less the same for each so it fits on).

5. When you’re done, click on the mail merge wizard and you should now be able to see each of the certificates (the first document will have all the names in the first column, the second document all those in the second etc.) You can now complete the merge and print off the four documents to produce personalised certificates for students with a different picture for each subject and the names of the members of staff.