BI Publisher Query - Send Bursted Email (HTML) with separate PDF Attachment
Summary
Is it possible to have two outputs in a BI Publisher Report?Content
Hello,
We have a BI Publisher report which sends an email (HTML) output, split and delivered by employee number, to certain employees. As well as the email itself, we'd like to be able to attach a document as a PDF to each email. Aside from setting PARAMETER6 in the bursting SQL to TRUE, I'm unsure as to how to indicate which document should be attached or whether this is even possible.
Any guidance would be appreciated.
Version
HCM 19CCode Snippet
SELECT ColleagueNumber as KEY, 'ReportTemplate' as TEMPLATE, 'HTML' as OUTPUT_FORMAT, 'en-UK' as LOCALE, 'EMAIL' as DEL_CHANNEL, Email as PARAMETER1, 'SenderEmailAddress' as PARAMETER3, 'EmailSubject' as PARAMETER4, NULL "PARAMETER5", 'true' as PARAMETER6, 'BCCAddress' as PARAMETER8
Tagged:
15