Posted: 2 Mar 2016 9:24 EST 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?
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?
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".