Hope my thread title was ok!
I have a worksheet with a list of date's on which different jobs are to be completed.
These dates are in a column and they are each meant for different users.
These users have their e-mail addresses stored in another cell on the same row as their relevant date of completion is.
I need a macro that will run continuously (will have this file open on a server) and consistently (once a day) check the system date against the dates in the column E and if the dates match then send an e-mail to the email address in the respective cell of column L.
I have looked everywhere and found similiar cases but none quite the same.
I have attatched a screenshot of the relevant columns.
Any help would be much appreciated