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

[kalyani23]

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

[Chetan Mahajan]

Hi Kalyani,

                         refer below thread https://community.servicenow.com/community?id=community_question&sys_id=1b417e9bdb475348200f0b55ca96...

Attach an excel file to email notification template

[kalyani23]

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.

[Chetan Mahajan]

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]

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