How to Display All CDO Records for a Single Contact in Email (Order Cancellation Scenario)

Hi Team,

We have a requirement to send Order Cancellation emails to customers who have canceled their orders. The data is stored in a Custom Data Object (CDO), which includes multiple fields like order number, product name, and cancellation code.In some cases, a customer has canceled multiple products (so there are multiple CDO records for the same contact). We need to list all those canceled items in a single email.

I have created the necessary field merges and dynamic content based on the cancellation code. However, while testing with Preview, only the last modified CDO record is shown in the email — not all the canceled items.