automatically send email from excel

[Guest]

I want to automatically send an email from excel when a certain value within
a cell is reached. Does anyone have a macro template to do this?? I have
other users accessing a common spreadsheet on a shared server and if they
enter data into this spreadsheet that causes a certain cell to hit a
predefined watermark that I have already setup, then I want to be able to
have excel automatically send an email to me alerting me that this watermark
or cell value has been reached.

I have already added Ron de Bruin's Excel "send email" add-in if this is
required.

Thanks.

 

[Ron de Bruin]

Hi Charlie
The problem is that Outlook have a security warning and if you use OE you must use
SendKeys to send a mail.

CDO is a option if you and your users have always a internet connection and
using Win 2000 or win XP.

Which mail program do you and your users work with?
Maybe i can give you a example then

 

[Celtic_Avenger]

As far as I am aware.....most excel email add-ins only open the defaul
mail client program, enter the details of the recipient, but do no
enter auto context or auto-send.

Celtic Avenge