Print worksheet as PDF and then Email?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I need to do is automate a workbook via a command button that when the
cells are filled with the data needed you can click the button and it will
PDF the file and then email it to the desired receipt. Any VBA code would be
greatly appreciated. I notice that MS Word has this function built in but
Excel doesnt?
Help Please!!!!
 
I guess I should have mentioned that I have 2003 not 2007. I have a command
button with the ability to send the worksheet via email but I need it to PDF
the file and then send via email. The web page is very helpful but like I
said I dont have 2007. The Guru's page only explains how to PDF the
worksheet, but not to email. Any more help you can give would be great!!!!
 
Back
Top