Dear Experts,

I have a excel sheet for service request and other details...and there is one column is target date. (means by which we should complete the task)

Now my requirement is to setup a macro so that it should check daily basis @ 9 PM (whether i have opened the workbook or not) and it send out an email using outlook
the body of outlook message should be based on below formula : target date - current date. for example : for example if target date 25th July , then today July 05 th..so message would be "20 avialble for fulfill request " and tomorow "it should be 19 days avialble to close the request) like this...
like this it has to check for records and send email accordingly...
actually whether i have closed or open the work book..windhow schdule should check automtically for everyday 9 PM

any ideas. please...