Send a grouped message

[Brigitte V]

Hello
I've created a table to keep track of loaned equipment. The table includes an end date and the equipment borrowed. I'd like to send a message to the person who has the equipment (asset=>assigned to) the week the loan ends. I've used Worflow studio. It works well, but it sends one email per piece of equipment. I'd like to group the material together and send a single email.
Can you help me?
Thanks

[Bhuvan]

@Brigitte V 

You can try to use email digest for consolidated notifications.

https://www.servicenow.com/docs/bundle/zurich-platform-administration/page/administer/notification/c...

Alternate option is, create event to track loaned assets nearing return and use schedule job to trigger email notifications on daily basis based on loaned to users. Refer below for similar requirement,

https://www.servicenow.com/community/itsm-forum/consolidate-multiple-email-notification-in-a-single-...

If this helped to guide your or answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[Bhuvan]

@Brigitte V 

Did you get a chance to review this ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan · Accepted solution]

@Brigitte V 

Thanks for marking the post as helpful.

If my response helped to answer your query, please accept the solution.

Thanks,

Bhuvan

[Brigitte V]

Thanks for the reply.
That taught me a function I didn't know about.
I created an event, a notification, and a scheduled script (Scheduled Job).

Brigitte