E-mail an Excel worksheet from a hyperlink

[ka4016]

I am trying to setup a hyperlink in an excel cell to e-mail a worksheet from a workbook when the hyperlink is clicked. If this is not possible, then is there a way to do this from a button or soemthing else. I am using Excel 97 and 2000.

I am trying to basically automate the "e-mail" button that is available on the toolbar that will e-mail a single worksheet within an excel workbook, and it will e-mail it as the text of an e-mail, not as an attachment.


Thanks.

 

[ETID]

There is an option to email to Mail recipient that does not put it as an attachment. You can either go to File, Send To, Mail Recipient, or put the button on your toolbar. The button has the file and envelope without the paper clip.
Hope this helps.

 

[ka4016]

Thanks for the answer,

but I am trying to automate that task through a hyperlink. Basically what I am trying to find out is, what is the code behind the pushing of that button, or the VB code behind selecting File/Send to/Mail Recipient.

Any suggestions are appreciated.