How to add a group in "CC" in an Email Notification?

[Community Alums]

Hi,

I have one requirement: I need to add a group to the 'CC' in an email notification using an email script.

Note that - this group doesn't have an email ID, so I need to send the email to the individual members of the group.

For example, if there is a group called 'Global' with five members, I need to add those five members to the "CC" 

[Community Alums]

You may try using within the script:

email.setCc('abc@xyz.com', 'pqr@xyz.com');

[SP22]

Hello @Community Alums ,

Can you please try this email script and let me know whether it is useful or not.

// Get the group from the current record dynamically (e.g., assigned group on an incident or task)

var groupSysId = current.assigned_group;  // Replace 'assigned_group' with the correct reference field

if (groupSysId) {  // Check if the group field is not empty

    var group = new GlideRecord('sys_user_group');

    if (group.get(groupSysId)) {

        // Loop through all the members of the group

        var groupMembers = new GlideRecord('sys_user_grmember');

        groupMembers.addQuery('group', group.sys_id);

        groupMembers.query();

        

        // Check if there are members in the group

        if (groupMembers.hasNext()) {

            while (groupMembers.next()) {

                // Dynamically print each member's email

template.print(groupMembers.user.email + ', ');

            }

        } else {

gs.log('No members found in the group: ' + group.name);

        }

    } else {

        gs.log('Group not found with sys_id: ' + groupSysId);

    }

} else {

    gs.log('No group is assigned to this record.');

}

 
Thanks
SP.

[Rohit99]

Hi @Community Alums,

You may try with the following mail script.

Script :

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,

    /* Optional EmailOutbound */

    email, /* Optional GlideRecord */ email_action,

    /* Optional GlideRecord */

    event) {

    var gr = new GlideRecord('sys_user_grmember');

    gr.addQuery('group', 'd3afa0d883301210d3ebb755eeaad311'); //sys_id of specific group

    gr.query();

    while (gr.next()) {

        email.addAddress("cc",gr.user.email,gr.group.getDisplayValue());

    }

})(current, template, email, email_action, event);

and in Notification Body just add:

${mail_script:your_mail_script_name} 

Please mark my response as correct and helpful if it helped solved your question.

Thanks,

Rohit Suryawanshi

[Ayushi12]

Hi @Community Alums,
You can write the email script and call email script in notification.
Refer below code:
In Notification Body add - ${mail_script:<Your script name>} 
e.g: ${mail_script:test_email_script}  
Email Script - 

    // Add your code here

    var grpemail= new GlideRecord('sys_user_grmember');

    grpemail.addQuery('group', '287ee6fea9fe198100ada7950d0b1b73'); // Replace with sys_id of the required group

    grpemail.query();

    while (grpemail.next()) {

         email.addAddress("cc",grpemail.user.email.toString(),grpemail.user.name.toString());

    }

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks!