Formatting Custom Field Data in SAP Marketing Cloud Emails

[bmassaro]

Hello community,

I have a question about formatting data in SAP Marketing Cloud. We are loading interaction data into custom fields and want the data to format in a table that looks presentable to the customer. I am struggling to get the data into a presentable format:

When we pull the data fields into the email for the interactions we are targeting, our data gets grouped together, which is not how we want the email to be formatted:
Order: 1111222234, 3333444456

Date: 20211028, 20211123

2 x TN326 TONER, 1 x TNP63 UAR FOR BIZHUB 4752-4052 (YLD 25K)

Instead, we would like a format similar to this so it is easier for our customers to read:

Line Order Date Material Description Status
1 293802938 11/15/2021 AW8970 TN232 Toner Awaiting processing
2 239209380 12/13/2021 A9AW98 TN345 Toner Awaiting processing
Does anyone have guidance on how to get this data formatted correctly?

Thanks,

Brittany

[MichaelRey]

Hello Brittany,
we offer already to add interactions into emails. Then the formatting comes out of the box.
See here the documentation.
Best regards
Michael