How would you go about mail merging this set of data

[willsonfang]

Hi,



I have very little mail merging experience, apart from basic knowledge of it.

Here is my issue,

I have a dataset that contains values for 3 tables, 2 of the 3 tables can have multiple rows, where the other one is always 1 row.

In the same dataset, it also contains normal merge fields (straight mapping).

Attachement is an example of the data. (and yes thats how the data comes in, not very mail merge friendly)

Any help would be appreciated.