Send multiple notifications in one email

  • 11 February 2017
  • 5 replies
  • 9 views

Badge +3

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


5 replies

Badge +16

Hi

A site workflow is the way to go for sure - very similar threads here:

https://community.nintex.com/message/40627

https://community.nintex.com/message/10124

https://community.nintex.com/message/44886-re-single-email-multiple-list-items

https://community.nintex.com/message/46276-re-how-do-you-send-a-single-email-for-multiple-list-items

Are they any help in guiding you on a way forwards?

Badge +3

Hi Cassy,

I'll try these!

Thanks for your help. 

Badge +16

how did you get on?

Badge +3

I made a site workflow as you suggested with loops in loops!!

Query "whos"

   For each "who"

      Query "project"

            For each "projects"

                  Get "who" collection on the project

                     Query "tasks"

                         For each "task"

                            Get "who" collection on the task

                            Get "project" collection on the task

Send Notification

A bit hot but it works

Thanks a lot!

Badge

Hi Patricia, i am try to do the same thing but it not working.can you show how you do it ??

thankk!!!

Reply