Send email on clicking a button inside excel

[mirage10]

Hello,
We have an excel file sitting on a shared drive where the problems are logged by the users. Is there any way that the users can click a button and an email is sent to one particular person with 'check the status' as the subject ?
any advise will be appreciated.
Thank you!

------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[SkipVought]

Hi,

Check the SendMail Method.

Skip,

_[red][/red]

 

[Asspin]

I used this a couple years ago for something like this. Hope it helps.

'This code will cause an e-mail to be sent
Set ol = CreateObject("Outlook.Application")
Set olns = ol.GetNamespace("MAPI")
Set olmail = ol.CreateItem(olMailItem)
With olmail
.To = "email address"
.Subject = "Subject"
.body = "Body"
.Send
End With


Dan