question How to set "Who will receive" through mail script? in ITSM forum

How to set "Who will receive" through mail script?

m_servicenow — Fri, 20 Jun 2014 06:13:06 GMT

Hi Everyone,

I want to add "Who will receive' from <mail_script></mail_script>. is there any way by which we can set user/group filed in "Who will receive".

I m writing this code as below in <mail_script> in email template. But this is not working:

<mail_script>

var gr = new GlideRecord("change_request");

gr.addQuery("number", current.number);

gr.query();

if(gr.next())

{

var emailto=gr.requested_by.user_name+"@example.com";

email.setTo(emailto);

}

</mail_script>

Re: How to set "Who will receive" through mail script?

darshanr — Fri, 20 Jun 2014 06:19:14 GMT

Hi Mukesh,

You can add Email Address in your mail script by below method

email.addAddress("cc", "User's Email","Name");

email.addAddress("bcc", "Group's Email","Group Name");

But for 'To' you can make use of parm1 and parm2 functionality of Email Notifications

Re: How to set "Who will receive" through mail script?

Pradeep Sharma — Fri, 20 Jun 2014 07:13:00 GMT

Hi Mukesh,

Please check the below thread which will be helpful

https://community.servicenow.com/message/695278#695278

Thanks

Pradeep Sharma

Re: How to set "Who will receive" through mail script?

harikrish_v — Fri, 20 Jun 2014 07:43:27 GMT

Hi Mukesh,

If you are triggering the email notification with an event, you can pass the recipients id as a parameter in the event call itself ie

gs.eventQueue("myevent.called", current, gs.getUserID(), gs.getUserName());

here parm1 is gs.getUserID() and parm2 is gs.getUserName(). In the email notification, you can select the advanced view, change 'Send when' to 'Event is fired' and you can see that in the 'Who will recieve' you have these options 'parm1 has recipient', 'parm2 has recipient', you can check that to send the email to them.

cc and bcc can be controlled via script, you can refer this wiki link for more details:-https://wiki.servicenow.com/index.php?title=Scripting_for_Email_Notifications#Adding_CC_and_BCC_Recipients

In a nutshell, you can use the below script add people in cc and bcc:-

<mail_script>


       //email.addAddress(type, address, displayname);


       email.addAddress("cc", "john.copy@example.com","John Roberts");


       email.addAddress("bcc", "john.secret@example.com","John Roberts");


</mail_script>

Hope this helps.

Thanks & Regards,

Hari

Re: How to set "Who will receive" through mail script?

ryadavalli — Tue, 26 Jan 2016 15:07:13 GMT

HI Harish,

I am trying to send the email notification to bcc and cc but not to have an to address.

The lines you mentioned above <mail_script> email.addAddress......, should be put in the email notification body ?

Thanks,

Re: How to set "Who will receive" through mail script?

Ravi Prasad1 — Tue, 26 Jan 2016 15:14:51 GMT

Yes in email notification body.

You can pass user sys_id as well if you dont have email ids.

Re: How to set "Who will receive" through mail script?

ryadavalli — Tue, 26 Jan 2016 15:25:04 GMT

YUp it worked, but one question is we cannot have bcc or cc without to right ?

Re: How to set "Who will receive" through mail script?

Ravi Prasad1 — Tue, 26 Jan 2016 15:28:46 GMT

Never tried without To field. You just give a try.

Let me know the result as I am also interested to know the result !!!

Re: How to set "Who will receive" through mail script?

ryadavalli — Tue, 26 Jan 2016 15:38:00 GMT

Sure. THanks Ravi. There is another question which I have related to something else. Can you please see my question to the article

THanks,

Re: How to set "Who will receive" through mail script?

adarsh-homepage — Wed, 13 Jul 2016 13:50:20 GMT

Hi Ravali,

Could you please share a screenshot from the notification body where exactly you have written the mail script in Geneva. Also if you could provide script to cc users manager would be great.

Regards

Adarsh

Re: How to set "Who will receive" through mail script?

ryadavalli — Wed, 13 Jul 2016 15:22:33 GMT

Here is the email notification body:

Short description: ${short_description}

${mail_script: your mail script name}

In the email script, you can use:

(function runMailScript(current, template, email, email_action, event) {

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

var id = current.caller_id;

var user = new GlideRecord("sys_user");

if(user.get(id))

{

if(user.manager != '')

{

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

}

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

Re: How to set "Who will receive" through mail script?

jnimmala — Wed, 30 Aug 2017 13:41:45 GMT

On Istanbul, the "Event parm 1 contains recipient" is missing. Is this still supported. My notification is fired on an event.

Am I missing something?

Thanks,

Jay

Re: How to set "Who will receive" through mail script?

Pradeep Sharma — Wed, 30 Aug 2017 18:29:37 GMT

Can you please click on the related link "Advanced view" and check again. In case you still don't see this then personalize the form layout and make sure the field is present on the form.

Re: How to set "Who will receive" through mail script?

johnram — Thu, 21 Sep 2017 20:35:23 GMT

The ServiceNow Wiki content is no longer supported. Updated information about this topic is located here: Scripting for Email Notifications

Visit http://docs.servicenow.com for the latest product documentation

Re: How to set "Who will receive" through mail script?

Scott Murphy2 — Tue, 06 Mar 2018 20:12:59 GMT

I have a similar requirement and used a mail script to modify the email_action.recipient_users directly.

(function runMailScript(current, template, email, email_action, event) {
	var user = new GlideRecord('sys_user');
	user.addEncodedQuery('user_name=' + current.sys_created_by);
	user.query();
	while (user.next()){
	email.addAddress("to", user.email,user.name);
	template.print(user.name);
	email_action.recipient_users += user.sys_id+",";	
	}
})(current, template, email, email_action, event);

Re: How to set "Who will receive" through mail script?

Allen5 — Thu, 19 Apr 2018 07:57:11 GMT

Hi stmurphy,

Thanks for your code sharing. I also have a similar requirement, but I need to add an email address, instead of a user. Reason is that I need to force (and test if exists) a secondary email address.

When I try to add this email to "recipient_users, it doesn't work. I tried your code (to add an email address):

email_action.recipient_users += ",test@test.com,";

I even tried (to replace existing users/emails addresses):
email_action.setValue('recipient_users',mailaddress);

Paradoxaly, logging displays correctly the email address that I set by script:
gs.log('resulting recipient_users : '+email_action.recipient_users);

But when I look to sys_email, recipiends are not good (as if my code wasn't executed).

Is there any complementary action to apply, configuration to verify ?

Tried on OOB dev instance (Jakarta) and another one, unsuccesfully.

Thanks,

Arnaud

Re: How to set "Who will receive" through mail script?

Lavanya D — Wed, 27 May 2020 07:22:53 GMT

Hi ,

I have the same requirement of sending a secondary OOB email to a email address "abc@gmail.com". Please help me out with this email script.

Thanks,

Lavanya

Re: How to set "Who will receive" through mail script?

Scott Murphy2 — Wed, 27 May 2020 14:19:38 GMT

Lavanya,

I think you can only use a user account with this. If you make a user account with this email address then supply the sys_id of that user it should work.

Re: How to set "Who will receive" through mail script?

Scott Murphy2 — Wed, 27 May 2020 14:21:54 GMT

Lavanya,

You can cc email addresses that are not users in the system by using the email object.

https://docs.servicenow.com/bundle/newyork-servicenow-platform/page/script/server-scripting/reference/r_ExScptEmlNtfn.html