Add users to CC field in email?

Edwin Fuller
Tera Guru

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

1 ACCEPTED SOLUTION

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

20 REPLIES 20

Hansk
Kilo Contributor

Dear @Abhinay Erra , you Approach  helped mi even with a list collector instead of a triage. 
To sent a copy to the KB managers l(in a list collector of KB) of a related kb feedback knowledge base. In a email script. 

Thank you.

var grp = current.feedback.article.kb_knowledge_base.kb_managers+","; //store the sys ids  of the Kb managers list of the related feedback task  kb article where 'current' is the 'kb_feedback_task' table. The rest is Abhinay Erra's approach. 

var user = new GlideRecord("sys_user");
user.addQuery("sys_id","IN", grp);
user.addQuery("email", "!=", "");
user.query();
while (user.next()) {
email.addAddress("cc", user.email, user.getDisplayValue());
}