I have been given a task to send mails before the due date daily once to a partiular group of people till the task status is closed. the data will be in excel format.
3. Status open close and pending [ pending and open work on same lines]
4. Delivery date
5. alert frequency: each task will have a seperate alert email start sent date, for some it can be 2 days before due date and for others it can be before 4 days of due date.
6.email sent group also varies depending on the task.
7. all stop when the status is closed.
please help me with this as I am not that well versed with high end excel.