One list, multiple entries, one email

[markuden]

That's a good idea! I'd never thought of trying it that way. I'll have to have a play with that.

[akrasheninnikov]

See what you can do without calling a web service in my blog post: Query XML: Uses and limitations of URL Protocol queries from SharePoint Lists

[akrasheninnikov]

Also look at the answer I gave there: Re: email reminder + sharepoint 2010 list - it was accepted, and might be helpful here as well.

Hint: provide a link to a pre-filtered view of the list with or instead of a collection of links to separate items in the email.

[trish]

Hi Mark,

I have nearly the same question.

Here is what my list looks like:

PROJECT	TASK	WHO	DUEDATE
A	1	person1;person2;person3	02/25/17
A	2	person2;person4;person6	02/25/17
A	3	person1;person2	02/25/17
B	1	person4	02/25/17
B	2	person1;person6	02/25/17
B	3	person6	02/25/17
B	4	person1; person2	02/25/17
C	1	person3;person4;person5;	02/25/17
C	2	person4;person5	02/25/17

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 instead of one mail per task.

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

Now the mail is sent to person3:

Dear person3,

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

Project A

Task 1

Project C

Task 1

Hope it is clear!

Thanks for your help

PS: I have an on premise version