Send excel as pdf

[annadinesh]

Dear Team,

I want to send Excel sheet as pdf attachment through system's email button

Please help


Dinesh Saha

 

[Oaktree]

Which version of Excel are you using? On the newer versions, you can do this by just going to file --> share --> attach a copy instead (pdf).

 

[annadinesh]

Office 2007

 

[Oaktree]

In Excel 2007, I believe you have to do that in two steps. When you go to Save As, you can save the Excel file as a .pdf, but I think you'd separately have to attach the new .pdf file to your email.

 

[annadinesh]

Please provide a VBA Code to send excel sheet as pdf attachment in Office 2007 through Systems email button in Excel 2007