Basically i need to save the data on sheet 2 as a PDF and then attach that PDF to an email and send. I want to see the email before sending.
The name of the file is predefined with the data that is publicised in a cell after another macro is run.

The working code i have managed to mangle together is as follows; and this attaches the pdf to an email i just need some code that works to save the file in a pre created folder and as the same pdf file name as the email attachment. but im struggling. I have managed to save the pdf but then i cant attach to an email. 

Please Login or Register  to view this content.
any help greatly received.
Thanks
Aaron