Convert HTML file to PDF (via MS Access)

Andy Brown
Andy Brown used Ask the Experts™
on
I need to create a PDF file from MS Access.  

The reason for this is so that I can create a HTML template (with images, text and merge fields), add field data into the HTML file (contact, company name etc), generate a PDF and then attach that file to an email.  I can get it to the point of having a HTML file - but can't see a way of saving that as a PDF.

I can't use an online tool as it needs to be automated in the background, and the Access application will be running on a hosted server, so I don't want any additional third-party products running (if at all possible).

Any ideas?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Localization Engineering & Automation
Commented:
Hi,
 You need to check this EE query and provided solution...

https://www.experts-exchange.com/questions/28346857/MSAccess-Convert-html-to-pdf-using-vba.html

Thanks,
Shail
Andy BrownDeveloper

Author

Commented:
Thank you Shailesh - I'll give it a go.
Andy BrownDeveloper

Author

Commented:
That'll do it - thanks again Shailesh.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial