Thread: How do I use macro in Excel 2007 to convert to and email PDF file
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default How do I use macro in Excel 2007 to convert to and email PDF f
See
http://www.rondebruin.nl/pdf.htm

There is also a mail example on that apge

--

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


"rick5555" wrote in message ...
Ron de Bruin,

Everything is actually accomplished in Excel 2007 - When recording the macro
I go to the Ribon on Excel 2007 and select Send and then Email as PDF
attachment it launches my email and attaches a PDF file of the spreadsheet I
am in. However, when I actually run the macro it does everything right but
it attaches the xls file instead of the PDF.


"Ron de Bruin" wrote:

Excel version ?

And which PDF program do you use

--

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


"rick5555" wrote in message ...
When I assign a macro to convert & sent PDF file it seem to work when I
record the macro but when I run it it attached an xls file instead of a pdf
file.

Reply With QuoteReply With Quote