How to send emails to all group members from sys_user_group

[Priyanka77]

Hi,
There is one table in which there is a field "assignment group" which is referencing to "sys_user_group" and i need to send 4 same emails to group members mentioned in current group. Below is the email script written but still its coming empty in preview email. It should look like in email "Hi name(name of that group member)" for 4 users
var Arr=[];
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('sys_id', 'current.group'); 
gr.query();
while (gr.next()) {
Arr.push(gr.user.name.getDisplayValue()); 
}

Can someone suggest some solutions.
Thanks in advance.
Priyanka

[Murthy Ch]

Hi Priyanka,

Can you try like this:

Go to the groups table and check the Include Members checkbox as shown below.

Hope it helps

Thanks

Murthy

[Priyanka77]

Thanks for your response.

This is not for particular one group instead it should work for all tables thats why i added group dynamically in script.

[Murthy Ch]

Okay got it.

Where are you writing this script exactly?

[Priyanka77]

In Email script

[Murthy Ch]

Okay and how are you returning it?

Can you share the complete code?