[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 821
  • Last Modified:

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);

Open in new window

0
systemsautomation
Asked:
systemsautomation
  • 2
1 Solution
 
rajvjaCommented:
you mean to show the report in the email itself when user clicks a button?

its not possible.
0
 
utter77Commented:
I agree with rajvja. Not possible.
0
 
systemsautomationAuthor Commented:
I want to show the report in the email WITHOUT clicking the button.

Is that possible?
0
 
rajvjaCommented:
Any events will not be fired I mean code will not be executed.

If you want to show the report, while sending email itself you can generate the report in HTML string and send in email. no issue in that
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now