Print to PDF / Save then Email PDF from within Excel

[muay74]

Hi All,

I'm after some help, (excel 2003).

The VBA steps I'm wanting to perform are as follows :-

1. Print a range of cells as a PDF
2. Save that PDF to a predetermined folder
3. Access that PDF and send it as an email from within excel

Any advice much appreciated.