I have a database that list my customers and the products they order. Example; I have customer ABC and they purchased three different products and each product they purchase has its own ID. The customer buys apples, 1 ID, Bananas 2 ID & Pineapple 3 ID.

I am trying to do a mail merge on a single word document and that has section for each of these products, all on the same page. I am trying to merge all three products to this one page. When I do the mail merge page 1 will have product 1 ID then when I go to the next page it has product 2 ID and so on.



How can I get multiple products to show up on page? Is this even possible?