AnsweredAssumed Answered

Send multiple notifications in one email

Question asked by trish on Feb 11, 2017
Latest reply on Apr 11, 2018 by florlopez

Hi,

I have a list in which there is a project name, a task description, who (multiple people picker) and a due date

 

PROJECTTASKWHODUEDATE
A1person1;person2;person302/25/17
A2person2;person4;person602/25/17
A3person1;person202/25/17
B1person402/25/17
B2person1;person602/25/17
B3person602/25/17
B4person1; person202/25/17
C1person3;person4;person5;02/25/17
C2person4;person502/25/17

 

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:

Dear person1,

Please complete the following tasks before 02/25/17 :

Project A

Task 1

Task 3

 

Project B

Task 2

Task 4

 

Hope it is clear!

Thansk for your help

Outcomes