Hi,

In this article, i will show you how we can add attachments to email. The recommended way is to use Include Attachments checkbox in the notification.

Once you check the Include attachments, the attachments associated with that record will be sent as attachment over the mail. This is pretty straight forward.

What if you want to send some other attachment through email which is not attached to this record but has to go along with this notification?

Option 1 (if that attachment is static like some disclaimer document that you want to send along with the notification of all records)

1. Upload the attachment in sys_attachment table through some record

2. Copy the attachment sys_id

3. Create a Before Insert Business Rule on sys_email table

Add conditions

Subject contains

Script

(function executeRule(current, previous /*null when async*/ ) {
    // Add your code here
            var grSysAtt = new GlideRecord('sys_attachment');
            grSysAtt.get('ab1fc95cdbaf101082f21780399619ff'); //mention your attachment sys_id
            var content = new GlideSysAttachment().getContentStream(grSysAtt.sys_id);
            new GlideSysAttachment().writeContentStream(current, grSysAtt.getValue('file_name'), grSysAtt.getValue('content_type'), content);
})(current, previous);

Save

This will send that specific document as attachment in the email.

Option2: what if you want to send a dynamic attachment but not directly linked to this record

For Example, Fetch the parent incident documents along with the child incident documents and send it as attachment.

Business Rule on sys_email

Before insert

Conditions

Target table is incident

subject contains ...

Select Include Attachments checkbox in the notification (This will attach all the emails of your child incident)

Script to fetch parent incident attachments

(function executeRule(current, previous /*null when async*/ ) {
    // fetch the parent incident
    var gr = new GlideRecord("incident");
    if (gr.get(current.instance)) {
    var parent = gr.parent;
        var grSysAtt = new GlideRecord('sys_attachment');
        grSysAtt.addQuery("table_sys_id", gr.parent);
        grSysAtt.query();
        while (grSysAtt.next()) {
            var content = new GlideSysAttachment().getContentStream(grSysAtt.sys_id);
            new GlideSysAttachment().writeContentStream(current, grSysAtt.getValue('file_name'), grSysAtt.getValue('content_type'), content);
        }
    }
})(current, previous);

Let me know if you have any questions in the comments below.

Mark the article as helpful and bookmark if you found it useful.

Regards,Asif

2020 ServiceNow Community MVP