I have a hierarchical dataset in my job, and want to use it to generate emails.  I would like one email per parent row, containing header text from the parent, followed by one line per child row containing text from several fields, followed by footer text from the parent.

When I set that up what I get is the header text, followed by one line per child row *and* the footer text.  So, the footer is repeated for each child row.

If I want to format the email with HTML so that the child rows are in a

, and open the

in lines preceding the lines for the child rows (so, in the header), and close the

in the footer, IMan seems to insert closing

or

tags before any child row is emitted, and the closing tags intended for the footer are repeated for each child.

I also tried using an Aggregate and a Map to create a field in the parent row containing the exact HTML to insert in the email.  That throws an error (something incomplete like "Email must be in the form ."), but the markup renders fine in Preview (and I used Chrome's inspector to verify that the output was well formatted).

Any ideas?  Or should we add this to the wish list?