Thank you Peter.

So the Range. Paragraph object referred to in the code refers to a line on the document (line the row object in Excel). Since the Employee name is on line 5 I'll modify the code from (1) to (5) per your suggestion.

How does the code know to create a new PDF for each employee (just curious).

I'll create a dummy couple of pages and send this to you later today or tomorrow. Thank you for your help on this, you're a life saver!

Michael