I have a list in which there is a project name, a task description, who (multiple people picker) and a due date
There can be multiple lines for a project, as many times there are tasks.
I need to send an email 3 days before the due date to the persons in the "Who" column BUT only for the tasks where they appear. I would like to send only one mail which will display all the tasks the person has to complete.
Example: 3 days before "02/25/17", the site workflow is supposed to send a mail to each person in the "who" column.
I assume the mail is sent to person1:
Please complete the following tasks before 02/25/17 :
Hope it is clear!
Thansk for your help