Send email with BIP RTF generated report as an attachment on APEX
Apex application runs reports using a BI Publisher server- using a defined query and RTF template. When the end user clicks on a button, a PDF report is generated for the query and layout created. It is working well.
Now, when the user enters an email and clicks on the button, apex should automatically send an email having this generated BIP report as an attachment.
How can I achieve this?