Sending customers a list of orders of part X

[ScottM47]

Is it possible to use merge fields to insert a complete table (in this case a list of orders, qtys, etc.) for each customer receiving the e-mail?  This data would all be in a CSV.  The "table" would be a single field in any format required (text,csv,html,etc.).

That's because I'm assuming there is no recursive merging like you can do in 

EXAMPLE:

Dear Customer X

Our records show you've bought part Y - etc...

SHIPMENT DATE	PO	QTY
07/01/2024	XX1	24
07/15/2024	XX2	36
08/15/2024	XX3	10

[William_A]

Hello @ScottM47 ,

There isn't a way to accomplish this in the email builder, since it's not built for pulling that kind of info and compiling it in either an auto-generated or manually-created way.

[ScottM47]

Thanks for the quick feedback.

So just to be clear - I couldn't have an html coded table or plan text table as a merge field? (examples below)

HTML

"<table><tr><th>SHIP DATE</th><th>QTY</th><th>PART ID</th><th>ORDER ID</th><th>SHIP TO</th></tr><tr><td>2024-10-23</td><td>3</td><td>XXX</td><td>YYY</td><td>1</td></tr><tr><td>2024-10-23</td><td>3</td><td>XXX2</td><td>YYY2</td><td>1</td></tr></table>"

PLAIN TEXT with tabs and line feeds

"SHIP DATE QTY PART ID ORDER ID SHIP TO

2024-10-23 3 XXX YYY1 1

2024-10-23 3 XXX2 YYY2 1"

[William_A · Accepted solution]

You're welcome to try via the custom code editor, however since the email would be wholly custom-made, our hands would be tied on providing any insight or troubleshooting if the code isn't working as you'd intend.

These articles would likely be the most useful:

Create an email with custom HTML code

Add dynamic links to a custom code email

Using variable tags in Constant Contact email, landing page, and SMS editors