Hi,
I've created a process that take data from a database and create a collection like that in fig1.
This data must by taken from Outlook for send emails to those recipients and remind them that the activities must be completed within a certain date.
The process works fine, but Outlook send one mail to each recepient for each activity and it's not what we want to do.
I need to group for each recepient all the activities that must be completed like that in fig2 and send to them only one mail with all the expiring activities.
I think I need to create another collection but I have no idea how to group the data in the mail column. Can someone help me?
Thanks
I've created a process that take data from a database and create a collection like that in fig1.
This data must by taken from Outlook for send emails to those recipients and remind them that the activities must be completed within a certain date.
The process works fine, but Outlook send one mail to each recepient for each activity and it's not what we want to do.
I need to group for each recepient all the activities that must be completed like that in fig2 and send to them only one mail with all the expiring activities.
I think I need to create another collection but I have no idea how to group the data in the mail column. Can someone help me?
Thanks