Is it possible to schedule reports via email body rather than excel/pdf attachment.

mahesh-gupta · ‎10-03-2022

Baala T · ‎10-13-2022

Hi Mahesh,

There is a work-around.

Entire report should be coded in Notification Script using GlideRecord and template.print. This way we can fulfill your requirement.

Few drawbacks also there in it.

- Maintenance would be difficult when there is a need for minor enhancement

- EMail body size will increase

Regards,

Bala T

View solution in original post

SanjivMeher · ‎10-13-2022

As suggested by Bala, notification script can be used to print the table in the email.

In that case you will have to use a Scheduled script to generate the event. And the event should trigger the notification. the notification should use a notification email script to print the data in the email body. As mentioned, it may increase the email body size if the data is too much.

If it is an image, you can specify ${report:png} in the introductory message and set type as Embedded PNG in the Scheduled Report

Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

Ankur Bawiskar · ‎10-03-2022

Can you explain what do you mean by email body rather than excel/pdf?

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

mahesh-gupta · ‎10-13-2022

can we include the content of the file attached in the mail body

Ankur Bawiskar · ‎10-13-2022

Hi,

file can be pdf, excel etc

why to include that in email body and increase the size of email content/text.

Let it go as attachment.

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

mahesh-gupta · ‎10-13-2022

the requirement isto have it in the mail @Ankur Bawiskar , thanks for the response