Mail Script - CC the email address from Watch List

[Jon S_]

So I've implemented the following mail script for Users from the Watch List to be cc'd and it works great. Problem is, we also want to include email addresses added manually to the Watch List (e.g. a Distribution List email address) but I'm hitting a wall on how to write this in or if it needs to be a different mail script altogether. Basically, CC everything from the Watch List and not just Users in the system but also email addresses. Any help would be appreciated.

if (!current.watch_list.nil()) {

    //get watch list addresses and add to cc

    var watcherIds = current.watch_list.split(",");

    //get user records

    var user = new GlideRecord("sys_user");

    user.addQuery("sys_id", watcherIds);

    user.addQuery("notification", 2); //email

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

    user.query();

    while (user.next()) {

    //add to cc list  

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

    }

}

[justin_drysdale]

This code doesn't pickup manually added addresses? Hmm, I think you'd have to loop over each value in the watchIds array like this (untested):

if (!current.watch_list.nil()) {
     //get watch list addresses and add to cc
     var watcherIds = current.watch_list.split(",");

     var len = watcherIds.length;
     for(var i = 0; i!=len; i+=1) {
                 if(watcherIds[i].toString().indexOf("@") > -1) {
                   //regular manual email address with an @ symbol:
                   email.addAddress("cc", watcerIds[i], watcherIds[i]);
                 }else{
                   //service now user sys_id:
                     var user = new GlideRecord("sys_user");
                             user.addQuery("sys_id", watcherIds[i]);
                             user.addQuery("notification", 2); //email
                             user.addQuery("email", "!=", "");
                             user.query();
                                 while (user.next()) {
                                 //add to cc list 
                                 email.addAddress("cc", user.email, user.getDisplayValue());
                                 }
                 }
     }
}     

[Jon S_]

Unfortunately, it does not. And I'm surprised that in all my research and how many people are using this that nobody else has either noticed or reported it (or needed it). I tried your code, fixing watcerIds[i] but no luck. Any ideas?

[SanjivMeher]

This is what I do. Because there could be email addresses which are not users.

if (current.watch_list!='')

{

var watchlist = current.watch_list.split(',');

for (var i=0;i<watchlist.length;i++)

{

var iuser = new GlideRecord('sys_user');

iuser.addQuery('sys_id',watchlist[i].toString());

iuser.query();

if (iuser.next())

email.addAddress("cc", iuser.email.toString());

else

email.addAddress("cc", watchlist[i]);

}

}

[Jon S_]

Strange... this one doesn't work for me. It won't even include the regular users let alone any email addresses.