auto email reminders

[ultratch47]

the problem is simple however i fear the answer is otherwise...here goes nothing

if cell c7 has a date of 6/26/2002, i would like to receive an email on this specific date reminding me of this excel sheet... i'm not picky, the email doesnt have to contain anything, could just be a subject line saying "reminder, worksheet1"

(any suggestions on where i can go to further my knowledge of using VB with excel?)

 

[ultratch47]

another question, if C7 is todays date, i would like to auto color this cell red (any color) for higher visibility, after the date listed in C7 has passed, turn this cell yellow... before all the days of the date listed in cell C7, the cell should be a diff. color... any suggestions?

 

[lenze]

It might be possible to write code to do this, but it is well beyond my ability or interest. Here's what I do. I create a task in Outlook to remind me and place a shortcut to the workbook inside the task. I usually make the task recurring. When the task prompts me for action, I click the shortcut, do my thing and save.

HTH
This message was edited by lenze on 2002-08-20 13:42

 

[lenze]

For your second question,use Conditional Formatting for Cell C7

Formula is =C7=Today() Format Red

Formula is =C7<Today() Format Yellow

Etc.
This message was edited by lenze on 2002-08-20 13:43