Thread: Command Button - Macro to print to pdf, then send pdf to email.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Command Button - Macro to print to pdf, then send pdf to email.
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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tdahlman" wrote in message ...
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
Reply With QuoteReply With Quote