Email a worksheet help

[munkee]

Hi people me again,


I have a sheet which contains data that needs to be collated up to a team leader. In order to do this I would like to add a button to the sheet which once clicked will open up excel and attach just that sheet to the email with the subject that i define.

The email will be sent using outlook and i expect will be easiest if the sheet is just an attachement. Anyone able to write a macro that will be able to do this for me?

Thank you for any help

[DonkeyOte]

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

[jrdnoland]

This is something I use; you will have to modify it to fit your needs. I just copied the subs from the project I use it in.

Please Login or Register  to view this content.