So I have two date columns, I need help with a macro that can go into the first column (AK) and check for the dates, for each date that it finds that has already passed (smaller than today) it must go into the second column and check if the corresponding cell is empty (this will be on column AM). If the second column is empty I'd like for it to send an email with outlook to a person (email address is setup on column L) warning them to please check the why hasn't it been filled yet. If the corresponding cell on the second column (AM) is not empty, it can move on to the next. Lastly, if the date on column AK is bigger than today it can move to the cell below and if empty, the loop should stop.
Please help!
I had managed to find a macro here to check through the first column and warn me when the date is smaller than today:
Bookmarks