Creating a mail script that pulls over an attachment on a record

[Wayne Richmond]

I have an Email Client Template that populates the Email Client with text from records on a table [u_stationary_emails]. However, I've realised that the attachments on the records aren't being pulled across to the email client with the text. This is going to pose a huge problem if I can't get the attachment on the record to the email client because I'm using this as a sort of 'stationary/template reply'. Here's what happens in practice:

On my table [u_inbound_mail] I select a 'Stationary Reply' from a Reference field [referencing u_stationary_replies]

Press a button [UI Action] called 'Reply' which opens the Email Client in ServiceNow

The Email Client opens a Client Template

Within the template is the following mail script:

<mail_script>       
//get the sys id of the referring task   
var sys_id = current.sys_id;
//create a glide record to query the sys_email table for emails sent about this job   
var emailQuery = new GlideRecord("sys_email");   
emailQuery.addQuery("instance",sys_id);   
emailQuery.orderByDesc("sys_created_on");   
emailQuery.query();   
   
var qwer = current.u_stationary_reply.u_body; \\ THIS IS WHATS PULLING ACROSS THE TEXT
qwer += "\n";   
qwer += current.assignment_group.u_group_signature;
qwer += "\n";   
qwer += "\n _____________________________________________________";   
   
//Build the originating mail   
while(emailQuery.next());
{   
qwer += "\n To:";   
qwer += emailQuery.recipients;   
qwer += "\n From:";   
//qwer += emailQuery.user;   
qwer += current.u_sender;   
qwer += "\n Sent:";   
qwer += emailQuery.sys_created_on;   
qwer += "\n Subject:";   
qwer += emailQuery.subject;   
qwer += "\n _____________________________________________________";       
qwer += "\n\n"
qwer += emailQuery.body_text;   
qwer += "\n";   
}       
template.print(qwer);   
</mail_script>

So, does anyone know how I can pull the attachment(s) from the u_stationary_email records into this template?

Thanks

[Wayne Richmond]

Thanks Tim, that's worked near perfectly. Unfortunately the record has to be saved before the client can be launched and the attachment pulled over, however I've got around this by saving the record if the field is not empty on change.

[john0312]

Hi Tim,

Can you help me with this Include attachment using script .

Thank you.

[Jake Gillespie]

Hi Wayne,

Building on what Tim wrote, the simplest way would be to add a Business Rule on the sys_email table, and configure it to only trigger for specific cases (else it will fire for all email records).

The following would work for outbound emails from the sc_task table only:

Condition (Insert only):

current.type=='send-ready' && current.target_table=='sc_task'

Script:

GlideSysAttachment.copy(current.target_table, current.instance.sys_id, current.getTableName(), current.sys_id);

Regards,

Jake

[john0312]

Hi jake,

How to copy attachments from incident table to sys_email table.

Can you help me with this Include attachment using script .

Thank you.

[Jake Gillespie]

Hi John,

You can create a Before Insert/Update Business Rule as I described in my earlier post with the following details:

Condition (Insert only):

current.type=='send-ready' && current.target_table=='sc_task'

Script:

GlideSysAttachment.copy(current.target_table, current.instance.sys_id, current.getTableName(), current.sys_id);

This will essentially copy the attachments from the related record (in this case a Catalog Task) to the email generated in the sys_email table. You can modify the tables this applies to by changing 'sc_task' to another table of your choice.

I believe a more recent change to ServiceNow was to add the "Include attachments" checkbox on an Email Notification (definition) record. If you check this, it will do the same thing (e.g copy the attachments from the record to the email). Please see below for a screen capture.

Please note that the script you provided a link to in your message, will not copy attachments into an email but rather put hyperlinks into the email body, which point back to the ServiceNow instance so the user can click and download the attachments from ServiceNow rather than their mail server.

Regards,

Jake