Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locking Cells in an Automated SpreadSheet | Excel Discussion (Misc queries) | |||
how do i send an automated email from excel using an if statement | Excel Worksheet Functions | |||
Excel user defined functioned | Excel Worksheet Functions | |||
can an automated notification (on xls file changes) email can be | Excel Discussion (Misc queries) | |||
Automated Email Messages from Excel w/VBA | Excel Programming |