Command Button - Macro to print to pdf, then send pdf to email.
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
|