automated email for functioned cells
 

I have attached my file, I would like to have an email sent t
"skylinekiller.mail.telepac.pt" for every cell that has dropped belo
the 90 day mark (blue). On my worksheet I ahve a cell which turn
colors when the training date gets within 90 days, 30 days, and over 9
days. My question is, I was wondering if it's possible that once tha
cell falls with in the 90 days before training I want Excel t
automaticall send an email or some type of response. Is this possible

Attachment filename: training help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52989
--
Message posted from http://www.ExcelForum.com

automated email for functioned cells
 

Hi skylinekiller

I don't look at your file

You can use this event to run the macro if you want to check
Formula values

Private Sub Worksheet_Calculate()
'macroname
End Sub

You can adapt this macro
http://www.rondebruin.nl/sendmail.htm#message

--
Regards Ron de Bruin
http://www.rondebruin.nl


"skylinekiller " wrote in message ...
I have attached my file, I would like to have an email sent to
"skylinekiller.mail.telepac.pt" for every cell that has dropped below
the 90 day mark (blue). On my worksheet I ahve a cell which turns
colors when the training date gets within 90 days, 30 days, and over 90
days. My question is, I was wondering if it's possible that once that
cell falls with in the 90 days before training I want Excel to
automaticall send an email or some type of response. Is this possible?

Attachment filename: training help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=529898
---
Message posted from http://www.ExcelForum.com/