Hello all

If you remember my past messages, I have an email macro that sends a reminder email out to people if an adjacent column contains the value 5 (as in 5 days remaining until an item is due). Before i started this project, i wanted it to be fully automated. But in review of pros and cons.. making the macro autorun when the workbook is open is not feasable.. Because tons of people open this file daily and it would result in the workbook sending the same email over and over to people. Is there a way to make the workbook only run the macro once a day

Maybe somehow by putting the workbook to auto launch in the background at a certain time using windows scheduler... but i dont know how to make the macro start up during that time only... hm

any ideas? perhaps this is the wrong discussion group to be posting it on.. apologies if it is. But this is the only one i use and its somewhat related to programming since my whole project was based on that macro. heh

Thanks,
Lobo