Hi All,
Is it possible to sent e-mail via outlook to different users depending upon the system time. The system time to be compared with the specific column named "Deadlines" in excel and e-mail to be sent to concern person specified in the TO column of that row.
Before sending e-mail to the concern person all incoming mails to be checked whether e-mail sent to that particular deadline. If sent then the time of mail sent is to be documented in the column named "Time mail sent".
If not, alert to be sent and also, this is to be notified to the higher officials that "e-mail has been sent to the concerned person as job to be done by that person has missed the deadlines".
This is the urgent requirement.
Thanks for all your help in advance !!!!
Regards,
Sindhuja