Add users to CC field in email?

Edwin Fuller · ‎12-06-2016

I need to add two users to the CC field of an approval email notification template. I was told to use mail script but not sure how to write the script, any thoughts? The two field I need to add are "Primary Triage" and "Back Up Triage" which both are reference field to the sys_user table.

Thanks,

Edwin

Abhinay Erra · ‎12-12-2016

If that is the case use this script. MAke sure your field names are correct

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

/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,

/* Optional GlideRecord */ event) {

var ids=current.sysapproval.<primary triage>+','+current.sysapproval.<backup triage>;

var user = new GlideRecord("sys_user");

user.addQuery("sys_id","IN",ids);

user.addQuery("email", "!=", "");

user.query();

while (user.next()) {

//add to cc list

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

}

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

View solution in original post

Edwin Fuller · ‎12-07-2016

Screen shot below

Abhinay Erra · ‎12-07-2016

Can you also post the mail script screenshot? Is it named triage_users_email?

Edwin Fuller · ‎12-07-2016

Correct - Screen shot below

Abhinay Erra · ‎12-07-2016

which release are you on?

Edwin Fuller · ‎12-07-2016

Not sure what you mean by release, could you elaborate on that?