E-mail Alert for multiple users

[manisha_uit]

Hi All,

I have a requirement wherein I have contract managers ABC and XYZ (it can be more than 2)

Manager ABC has contract nos. 001 and 002

Manager XYZ has contract no. 004

I want to send a mail to these managers when a certain contract no is going to expire in 7 days. Suppose, for ABC, the message should be:

Contract nos 001 and 002 is expiring in 7 days

Similarly, for XYZ, it should be: Contract no. 004 is expiring in 7 days

I am using:

concat({<Days = {7}>}[Contract ID], ';') expression in the message body but this gives the entire list of contract nos.

Is there any way through which we can achieve this using a single alert

Thanks,

Manisha