Hi everyone

I have several excel spreadsheets that has classlists of students. Each
spreadsheet has seperate columns for student number (eg 1234567), surname
(eg Blogg) and firstname (eg Joe). There is a folder that has photos of
students (jpegs), each photo is in a seperate file and the filename is
student_number.jpeg (eg 1234567.jpeg). I am looking to create another column
for photos in the spreadsheet and have a script that inserts the picture of
the student by fetching it from the folder which contains all the photos.
Any ideas on how to do this or the scripts from someone who has already done
this would be greatly appreciated.

Thanks in advance.