About ScottM47

ScottM47 · ‎10-31-2024

If I have HTML data in custom fields, i.e. .TABLE_HEADER, TABLE1, TABLE2, TABLE3 and insert it as shown (in order to put a customer specific HTML table in an email). Breaking it up because the field character limit is 255. [[custom.table_header]][[custom.table1]][[custom.table2]][[custom.table3]] It is dropping characters and corrupting the HTML These fields are 250 characters long (just in case).If I concatenate these fields from the contact list they render correctly - so the HTML is good. Obviously I'm missing something - but I have no good way to see the HTML output of the resultant e-mail (since the e-mail reader messes with it so much). (or is there a good way?)

ScottM47 · ‎10-25-2024

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"

ScottM47 · ‎10-24-2024

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

About ScottM47

HTML editor and custom fields

Re: Sending customers a list of orders of part X

Sending customers a list of orders of part X