IFRAME in Email

Hello

I am sending email from our Workflow module in our Supply Chain application. The application is build on Oracle Application Express and Oracle Database XE.

The email contains some information about the Document which has to be approved. There is also a link to view the full document. This is a hyper-link which opens the report from Jasper Server in HTML format.

Everything till here works fine. Now I want to add a region in the email which should show the report directly without the need to click on the hyper-link. I tried this by adding IFRAME but this does not show the document in the email.

Please help me in showing the document in the email without the need to click on the link.

I am using the following code to generate email.

V_BODY :=   'Date: ' || V_WF_DATA.DATED || '<BR>'; --utl_tcp.crlf;
      V_BODY := V_BODY || 'Document Type: ' || COMMON.GET_DOCUMENT_TYPE( V_WF_DATA.DOCUMENT_TYPE_ID ) || '<BR>';
      V_BODY := V_BODY || 'Document No: ' ||  V_WF_DATA.DOCUMENT_NO || '<BR>';
      V_BODY := V_BODY || 'Requested By: ' ||  COMMON.GET_USER( V_WF_DATA.REQUEST_BY_ID ) || '<BR>';
      V_BODY := V_BODY || 'Supplier/Customer/Employee: ' ||  V_WF_DATA.B_PARTNER || '<BR>';
      V_BODY := V_BODY || '<a href="'||  V_SERVER_ADDRESS || V_WF_DATA.REPORT_URL || '> View Document </a>' || '<BR>' ;
      V_BODY := V_BODY || '<iframe src="' || V_SERVER_ADDRESS || V_WF_DATA.REPORT_URL || ' " height="450" width="530" scrolling="auto" frameborder="0">	</iframe>'; 
        
        
        

    apex_mail.send(
        p_to       => V_MAIL_TO,   -- change to your email address
        p_from     => V_MAIL_FROM, -- change to a real senders email address
        p_body => V_body,
        p_body_html => V_body,
        p_subj     => V_WF_DATA.WORK_FLOW_APP_DESC);

Select allOpen in new window