Email snap with both pipeline variables and HTML table?

[wpenfold]

I need to produce an HTML email that includes both pipeline variable information in the HTML header and an HTML table that is a multiline error report. I can make one or the other work, but not both. The error report is being read from a database table. I want the email to look like:

Pipeline aaaa was run with parameters x, y, z

Error Report:

GUROUTP_LINE

POPULATION SELECTION EXTRACT
CONTROL REPORT PAGE 1

ERROR Parm 3 must be entered if 1 and 2 are
SQLCODE = 0000
SQL ERROR =
X01 ROLLBACK SQLCODE=0000
X01 COMMIT (1) SQLCODE=0000
SQLCODE = 0000
ORA-01403: no data found
DQY-ABORT ROLLBACK SQLCODE = 0000
ORA-01403: no data found

[dmiller]

@rfduboissl if you put the HTML in the preformatted text format, it won’t try to generate the HTML within the Community post.

[LeeDuffy]

Late reply to this one!

The above solution I am implementing, but my requirement would be to send 1 email with any parameter or previous $data type values that aren't part of the table, and also bring through the table. I replicated the table and $data on the "same level", which is working nicely, however I am getting x number of emails sent as there are 9 documents, when I only need 1 email.

To resolve quickly, I added a Head snap which reduces the duplicate incoming stream to 1, just wondering if there is a better solution to reducing the documents to 1 for 1 email to be sent!