Dear Experts,
I need a solution for a day to day activity where a particular column to be read and accordingly a reminder mail to be sent with a Subject and body of the message in outlook mail. (In total 2 Reminder Mails - One at Day 60 and other at Day 29). But in case if the Status (Column H) is "Completed". Then Reminder mail should not trigger irrespective of days.
To check the Days remaining to review Column (Column M),
1. If the day reaches 60 days - a reminder mail to be sent to the person as per Email ID (Column F). Subject of the mail - (Column N) and Body of the Mail - (Column O). - Only One Reminder.
2. If the day reaches 29 days - a reminder mail to be sent to the person as per Email ID (Column F). Subject of the mail - (Column N) and Body of the Mail - (Column P).
Bookmarks