• Post category:BI Publisher
  • Post comments:4 Comments
  • Post last modified:June 16, 2020
  • Reading time:2 mins read
You are currently viewing Bursting attachment to Email along with html content in body
Bursting attachment to Email along with html content in body
- Bursting attachment to Email along with html content in body
Total Visits: 40

Normally when we burst the BI Reports we either do the html bursting so that the content will appear in the email body or burst with an attachment so that the end user can open the pdf and view it.

However if there is a requirement to combine both of them, then we can use the below bursting SQL:

select ‘1’                            KEY,
‘TEST’                               TEMPLATE,
‘RTF’                                 TEMPLATE_FORMAT,
‘en-US’                              LOCALE,
‘PDF’                                 OUTPUT_FORMAT,
‘EMAIL’                            DEL_CHANNEL,
‘Test Email’                       OUTPUT_NAME,
‘[email protected]’      PARAMETER1,
‘[email protected]’       PARAMETER3,
‘Test Subject’                     PARAMETER4,
‘<html>Hi’||’ ‘||’xxxx’||’,<br/><br/>
Human Resources was recently notified of your last day of employment. As a resigning team member of ABCD,<br/><br/>
we would like to gather some feedback from you about your experience at ABCD. Your candor and opinion matters.<br/><br/>
We share this feedback with leadership and engage in continuous process improvement.<br/><br/>
Our goal is to ensure we are consistently living our values and remain a top workplace.<br/><br/>
The survey will take approximately 10 minutes.  Please read each question carefully and select the response that best fits your experience.<br/><br/>
<a href=’ || ”’http://www.google.com”’ || ‘>Click here to take the Exit Survey</a><br/><br/>
Also attached to this email is a document outlining your final pay and benefits. After you have had an opportunity to review this document, please don’t hesitate to contact your HR Business Partners if you have questions.<br/><br/>
We wish you the best of success.<br/><br/>
Thank you,<br/>ABCD HR</html>’   PARAMETER5,
‘true’                                                      PARAMETER6
from dual

We need to populate the PARAMTER5 which is the body with the html content and this will show up on the email body.

Below is the sample email received by the end user:

image 35 - Bursting attachment to Email along with html content in body

If you have any questions, please feel free to reach out to me by posting in comments section.

If you are interested in learning Fusion Technical tools go through this post

If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.

  • Hello,

    I am using parameter 5 in my bursting query and using HTML as output format.While running the report it is not showing the email body but showing just the report. My BIP version is 12.2.1.4.

    Please help.

    Thanks

  • Hi Neha,

    Please share the bursting query for us to help you.. Do join our telegram groups for quicker response on your questions.

    Thank you
    Sricharan

  • Hello,
    I am using OUTPUT_FORMATE as HTML. The body of the mail content is in the RTF template. In the same RTF template, I am having two Docx type attachments. These two Dock attachments should come as the Same type in the mail. But I am getting as HTML type in the mail. Is there any solutions to get this scenario.
    Thank You
    Lokesh.

  • Hi Lokesh,
    I don’t think the attachments would get displayed in HTML.. You need to upload them somewhere and provide a link to download on the rtf template.. then those links would be visible on the html output.
    Thanks,
    Sricharan

  • In visible box by plugintheme