I am currently using the code below to export the active sheets from my workbook to Outlook in PDF format. I am looking to change the VBA code so that it does exactly the same thing as it does now with the exception of it being in PDF format. I want it to be in the same format as the current spreadsheet, which is .xlsm or it could even convert it to a regular .xls (the macro function is no longer needed once it is emailed)
Does anyone know how to update this code so that it will do this for me. I figure it's easy but I'm not sure how to change it.
Corrected the code boxes... are people allowed to reply now?
Bookmarks