Macro to auto-email separate worksheets of same workbook to separate recipients?

[Sean Anderson]

Hello,

I found a macro code that hides all worksheets except the one the user knows the password for.

But my company doesn't want to send en mass a workbook with hidden sheets because it is well known that Excel passwords can be easily recovered.

Does anyone know of a macro that will email each separate sheet to a specified list of intended recipients? Or do I have to keep emailing each sheet one by one?

I pray there is!

[mudraker]

Have a look at
http://www.rondebruin.nl/sendmail.htm

Especially
http://www.rondebruin.nl/mail/folder1/mail2.htm