So I've been having issues trying to get an email script to add either CC or BCC recipients correctly. I'm referencing the example in the wiki article about adding them in, but I'm not quite sure what I'm doing wrong. My notification email script looks like
var gr = new GlideRecord('u_trainees');
var training = event.parm1;
gr.addQuery('u_training.number',training);
gr.query();
while (gr.next()){
email.addAddress("cc", gr.u_email, gr.u_first_name + " " + gr.u_last_name);
}
and I'm calling it with
${mail_script:training_recipients}
in the notification.
As you can see, I'm not using the user table to grab people and names. I'm just finding the email field I made on a custom table and querying that table to get the trainees emails and names for the CC/BCC. Does anyone have an idea about what I'm doing wrong?
