I am trying to idiot-proof an excel file so that the user can push a button and it will convert to PDF and put into an Outlook window to send. In Excel 2010 it has the option to save and send as PDF and this works perfectly. However I have macro-recorded the process (code below) and when I run the macro, it puts the excel file into the email and not the PDF version.

I have looked in the folder where the file is temp saved to and it does create a PDF file, but it reverts to excel when put into the Outlook window. 

Please Login or Register  to view this content.
Any help is much appreciated. Thank you.