Forum Discussion
A_SIRAT
Jul 01, 2023Iron Contributor
Mail Merge using Multiple Rows
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...
Riny_van_Eekelen
Jul 02, 2023Platinum Contributor
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.
- A_SIRATJul 02, 2023Iron Contributorthank you though I already had this idea as explained above by creating additional tables on the right.
- Riny_van_EekelenJul 02, 2023Platinum Contributor
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.