|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
September 7th, 2004, 11:54 AM
|
|||
|
|||
email reminder
Please put me out of my misery, any ideas anyone,
I need excel to notify me by email when a cell reaches a certain date. the sheet is partly laid out as follows, Column A - Cell 1 - contains my "email address" Column B - Contains a date "when i passed my training" Column C - Contains a sum that determins a month before i am due to renew my training, =IF(B9>0,(B9+365*3-31),"" I then used Format Conditioning to turn this cell red when greater than todays date. Is it then possible to send myself an email when my training is overdue (greater than todays date) Thanks in advance KP1975
|
|
#2
September 7th, 2004, 03:53 PM
|
|||
|
|||
|
I'm sure you can use VBA to generate an email, but I have no details for you.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > email reminder |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
