I created a report rule to send email to the AR contact.

For the action property E-mail (Action Type = Preselect property) I wrote a Select query to fetch the AR contact’s e-mail address. When the Select query results out more than one e-mail address when there are more than one AR contacts, (or When I give two e-mail addresses separated by a semi colon ; ) ,the report rule is taking only the first e-mail address while it’s executing.

Is there any possibilities to get more than one e-mail addresses while the report rule is executing?

Any help would be appreciated.

Thank you!