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

mahesh-gupta
Tera Contributor
 
2 ACCEPTED SOLUTIONS

Baala T
Mega Guru

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
Mega Patron

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

SanjivMeher1_0-1665657482316.png

 

View solution in original post

11 REPLIES 11

Ankur Bawiskar
Tera Patron

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

mahesh-gupta
Tera Contributor

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

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.

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