For those who are frequent users of Email Client Template 
If so, I guess the approach being used would be download the attachments first & then get it attached to the Email Client. It may time consuming as it requires unncessary downlad first & then attach again. To remove the redundant step of download & then attach we can have an option where we can copy the attachments directly to Email Client template from the record.
Consider an example of Incident where you have 5 documents attached & all of these 5 needs to be sent you can have an option of 'Include Attachments' from Notification but you may not want the attachments to sent always & thus is not the option you may opt for.
In that case you just get a Before Insert/Update Business rule on Email (sys_email) table with below snippet & its done.
(function executeRule(current, previous /*null when async*/) {
// Add your code here
var lookforatt=new GlideRecord('sys_attachment');
lookforatt.addQuery('table_sys_id',current.instance);
lookforatt.query();
while(lookforatt.next())
{
GlideSysAttachment.copy('incident', current.instance, 'sys_email', current.sys_id);
}
})(current, previous);
What the above code does is just copies all the attachment from source (incident) in above case to Email Client. Something like below.
For instance a record has 3 attachments.
When Email Client Template is opened all attachments are copied.
GlideSysAttachment.copy('incident', current.instance, 'sys_email', current.sys_id);where 'incident' is source table & can be replaced with required table for copying the attachment from record to Email Client template.
Thanks,
Jaspal Singh
Hi people,
to resolve issue with duplicite entries, you have to set limit 1 to the query, it is because function:
GlideSysAttachment.copy('sn_customerservice_case', current.instance, 'sys_email', current.sys_id);
}
do always copy all attachments from a record so if you run it as many times as many attachments you have in the record you are creating duplicates.
Just change a function something like this:
I hope this will be helpful.
Hi people,
to resolve issue with duplicite entries, you have to set limit 1 to the query, it is because function:
GlideSysAttachment.copy('sn_customerservice_case', current.instance, 'sys_email', current.sys_id);
}
do always copy all attachments from a record so if you run it as many times as many attachments you have in the record you are creating duplicates.
Just change a function something like this:
I hope this will be helpful.
