Hi

Newbie here, I am looking for a macro which will do the following :
Send each worksheet in a workbook as a pdf to a different email address (stored in each sheet). I would also like the PDF name the same as the worksheet name if poss. The email will be sent via outlook.

It would also be helpful to be able to have a fixed subjet & message applied to the email.

Any help would be greatly appreciated.

T