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

  • Thread starter Thread starter Tdahlman
  • Start date Start date
T

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
 
Back
Top