Question
Tata Consultancy Services Pvt.Ltd
IN
Last activity: 9 Mar 2016 13:15 EST
Sending email with excel sheet as attachment (without WO)
We have one requirement that is we need to send some daily reports to business team automatically but now we are running sql scripts manually in sql developer and the results are exported to excel sheet, attaching that excel sheet to mail and sending to business team by manullay.Now we are using PRPC V6.1 sp2 and here is it possible to send automatic reports in 6.1 sp2? So can any one help on this?
Thanks in advance
Accepted Solution
Pegasystems Inc.
IN
Hi
Scheduling a report and send it automatically is available from 6.2 . Refer here : https://docs-previous.pega.com/how-schedule-reports-and-subscribe-scheduled-reports
For 6.1 x, you need to follow this article : https://docs-previous.pega.com/how-produce-pdf-reports-nightly-schedule
Tata Consultancy Services Pvt.Ltd
IN
Thank you Santanu. The above document will help how to save a PDF document in one shared location but here I have one question that in PRPC 6.1 sp2 Can we send excel attachments to mail automatically by Agent(Now we are running sql scripts manually in sql developer and the results are exported to excel sheet, attaching that excel sheet to mail and sending to business team)?Is it possible in PRPC 6.1 sp2 version?
Pegasystems Inc.
IN
Hi
I think it is doable but need to do some research to understand the exact steps involved .
John Pritchard-williams Rajiv Nistala any thoughts ?
Pegasystems Inc.
GB
Additionally: see this Post : seems to be a similar requirement : https://mesh.pega.com/message/213849#213849
Looks like the solution involved fetching an external file and then ( I think 'faking' an attachment page -but I'm not sure...) holding the file contents in an Attachments Page : and using the OOTB Activity "SendEmailNotification".
Cheers
John