Understood. However, I won't be able to get back to office until Jan 2 and i would like to be able to run it so I can convert the files to PDF then.

In the screensheet, the name file doesn't start until line 5 (two lines below "award").

How would I amend your code to have it look at the "Name of Participant" line for the name of the new PDF?

Do you need an entire document because i could probably make one from scratch but I wouldn't be able to provide the other 34 pages in the document.

Thank you for your help,

Michael