How to populate MailTo Body with request variables

[Nathan Okh]

I have a requirement to modify the MailTo script to change the Subject and Body. I used the following to modify the mail script:

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
          /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
          /* Optional GlideRecord */ event) {
	var subjectTxt = encodeURI('Re:' + current.number + ' - Accept Access Attestation');
	var bodyTxt = encodeURI('Please provide a business justification for your Access Attestation:   ');
	template.print('<a title="click here" href="mailto:YOURINSTANCEEMAIL@service-now.com?SUBJECT=' + subjectTxt + '&amp;body='+ bodyTxt+ bodyTxt+'">Click here</a>');

	
	}

However, the subject does not put the correct requested item number, and I have not been able to get the options variables to populate in the body.

I dont mind printing the variables individually rather than as a loop etc. simple is great at this point.

[Saloni Suthar]

To set the subject correctly, you need to use email.setSubject:
email.setSubject(subjecttxt);

[James Chun]

Hi @Nathan Okh,

Can you confirm if your notification is created on the [sc_req_item] table? 

I have copied your code and the subject looks fine to me.

In regards to getting all the variables, try the following script.

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */
    email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */
    event) {
    var subjectTxt = encodeURI('Re:' + current.number + ' - Accept Access Attestation');
    var bodyTxt = 'Please provide a business justification for your Access Attestation:   \n';

    var variables = current.variables.getElements();
    var vquest;

    for (var key = 0; key < variables.length; key++) {
        vquest = variables[key].getQuestion();
        bodyTxt += vquest.getLabel() + " : " + vquest.getDisplayValue() + "\n";
    }

    template.print('<a title="click here" href="mailto:YOURINSTANCEEMAIL@service-now.com?SUBJECT=' + subjectTxt + '&amp;body=' + encodeURI(bodyTxt) + '">Click here</a>');


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

Cheers

[KhushbooR]

Hello @James Chun @Nathan Okh 

How to call the email script on email template?

Thank you

Khushboo

[Nathan Okh]

I am pretty in the same way.

Navigate to System Notification > Email > Notification Email Scripts. to Create a email script

Navigate to > Email Client Templates, and add it there. Ex. ${mail_script:your_script_name}