IFRAME in Email

Posted on 2010-01-08
Last Modified: 2012-05-08

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





        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

Question by:systemsautomation
    LVL 11

    Expert Comment

    you mean to show the report in the email itself when user clicks a button?

    its not possible.
    LVL 4

    Expert Comment

    I agree with rajvja. Not possible.

    Author Comment

    I want to show the report in the email WITHOUT clicking the button.

    Is that possible?
    LVL 11

    Accepted Solution

    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

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    In this tutorial viewers will learn how to style a corner ribbon overlay for an image using CSS Create a new class by typing ".Ribbon":  Define the class' "display:" as "inline-block": Define its "position:" as "relative": Define its "overflow:" as …
    In this tutorial viewers will learn how to embed videos in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <video> tag to insert a video. Define the src as the URL of your video; this is similar to …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now