Command Button - Macro to print to pdf, then send pdf to email.

[Tdahlman]

I have a command button in my Excel spreadsheet where it will look at the
email address typed into a specific field and email the excel file to that
email address.
What I want to do is when I push the button, First have the page print to a
pdf, then send only the pdf file to the email address specified.

How do I add in the step of printing to a pdf.

Thanks in advance,
Travis

 

[Ron de Bruin]

Hi Travis

Code on my page for excel 2007 and a link to Ken's site for older versions
http://www.rondebruin.nl/pdf.htm