Jul 01 2023 10:09 AM
Hi,
I have attached this file where I would like to mail merge the first 3 rows of data into 1 word document. is this possible ?
I can manually create 2 additional tables on the right side with the same data and achieve what I want but maybe there is a better way of solving this.
Jul 01 2023 09:11 PM
Transform the data to nine columns wide by 3 rows with column headers like this:
ID1 Name1 Amount1 ID2 Name2 Amount2 ID3 Name3 Amount3
and then create the Word doc with mail merge placing these nine fields on each page where you want them.
Jul 02 2023 12:27 AM
Jul 02 2023 12:41 AM
@A_SIRAT Oh, then I didn't understand what you meant by "create 2 additional tables on the right side". My thinking was to create one table with nine columns.
Never mind, but I believe that's the only way.