How to send an record in excel format along with email notification

kalyani23
Tera Contributor

Hi, 

I have a requirement in which i want to attach record in excel format in the email notification.

please help me in implementing this.

Thanks & Regards,

Kalyani

4 REPLIES 4

Hi Chetan,

in the given link, they are able to send attachment that is attached in the record, but my requirement is, the record itself in export to excel format need to attach in email notification, is that possible, if yes please provide solution.

Hi Kalyani.

                     You can create a report on that table and schedule that report . You can select the email id to whom it should send that while scheduling the report. Please check below link to understand how to schedule the report.

DOC : Automate report distribution

Blog : Attaching an Excel file of a report to an email notification

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

is that excel stored on the record from where notification is triggering?

if not then you can do this

1) attach the excel of record based on some update etc to current record before the notification is sent

2) trigger notification by eventQueue() method once file is inserted into sys_attachment table

3) your event, notification would be on your table

Using CSV would be easier instead of Excel

Generate CSV file through script

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader