JonMillar 

In order to get further in your project, I recommend this page to you. It helped me a lot to automatically send PDF forms via Outlook. It shows different possibilities that could be used.

Ron de Bruin - Excel Automation

http://www.rondebruin.nl/win/section1.htm

Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.