markuden
Novice

Re: One list, multiple entries, one email

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

Reply
akrasheninnikov
Scholar

Re: One list, multiple entries, one email

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

0 Kudos
Reply
akrasheninnikov
Scholar

Re: One list, multiple entries, one email

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.

0 Kudos
Reply
trish
Rookie

Re: One list, multiple entries, one email

Hi Mark,

I have nearly the same question.

Here is what my list looks like:

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

 

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

Reply