E-mail a worksheet in excel from a hyperlink 1

[ka4016]

I am trying to setup a hyperlink in a 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.

Thanks.

 

[Databaseguy]

Oops......

Assuming you've got a MAPI compliant client (I.E. Outlook)

ActiveWorkbook.SendMail recipients:="Jean Selva" Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[JVFriederick]

I use this code to select and Email a particular file. You should be able to modify to suit your needs. BTW, a master file is open that contains the various lists of files to Email.

'Select and Email each file
MailName = Selection.Range("A1&quot ' get value from current cursor cell
MailFile = Selection.Range("B1&quot ' get value from current cell + 1 column to right
Windows(MailFile).Activate ' Activate the file to Email
ActiveWorkbook.SendMail Recipients:=MailName, Subject:="Here is the file ....." ' Send it

 

[ka4016]

Thank you for the responses, but this option sends the entire workbook as an e-mail attachment. 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.


I tried both of these solutions, and they work great, but it is not exactly what I am looking for.