How to send 1 email to all Assignee or value of customfield from a result of filter

Question

Hi all,

I create a filter for all service mgmt tickets that are due fo review or approval. Then created a scheduled automation where the Then: Lookup issues is the filter.

The body of the email includes a table listing whatever is the result of the filter, like this example:

The email works if I send it to myself. But how can I gather all Assignee and Remote Assignee and add them all in the To field of the email?

Thanks.

Grace Webster · Answer

I'm having this issue as well - the audit on the rule after the fail says the assignee field is blank. But i can put the same smart value into the body and works there. My guess is it fails when there is more than one assignee to send the email to. Any suggestions? Would like to use the rule over the subscription.

Zaldy Parian · Answer

Hi Joseph,

None of the tickets listed in the table in the email body is assigned to me. I also asked one of the Assignees, but no email notification came in into his Inbox.

Joseph Chung Yin · Answer

@Zaldy Parian -

In the issues that listed in your email body, are any of them assigned to you?  In addition, have to check with those issues' assignees to see if they have received the emails too?

Best, Joseph