Sorry I realize this is excel only but can I ask a MS word question here? I hope the answer is yes otherwise please redirect me.

We have a mail merge document which has over 100 sheets we would like to PDF each page to a separate file and name each file with a specific name.
Not sure how this can be accomplished weather we add the name inside the Word file and have it grab it from the word file or some other solution. I have not worked in the Word environment as far as VBA is concerned so not sure what this would look like. Is it possible to do this? Maybe someone already has a solution for this.

Our file naming standard is the employee name, underscore and the last name so here is an example. Eg. 125652_Smith

Thanks for your consideration.