Convert excel sheets to PDF and send via Outlook

[Stephanie30]

Hi

I am looking to create a VBA code whereby it converts and sends selective excel sheets as PDF via Outlook mail.

In order to avoid any errors and in order to make it easier, the sheet names are saved in range A1:A10.
The user should be able to send all sheets mentioned on the above range

any help ?

Thanks in Advance

Steph

 

[Rijnsent]

Hi Steph,

try checking out this post and/or post the code that you created:
http://www.mrexcel.com/forum/excel-...-code-convert-excel-pdf-email-attachment.html

Cheers,

Koen