vba to print active sheet to pdf, auto save in specific folder then mail using outlook

Hello there

How do I write a vba code to print active sheet to pdf, auto save in specific folder then mail using outlook

im using 'Nitro PDF Creator'

also id like it to automatically save the pdf as the same file name as the active worksheet and also auto enter the following when opening the email server:-

Address: Cell D18
Subject: Cell D21
Email body:

Paul

Please find attached quotation

• Optional installation available on request

thank you please help

this code may be helpful

Please Login or Register  to view this content.

Hello there

thanks for this although i seem to be encountering an error a per attached:-