Mail Merge : All-in-1 Page with Complex Scenario

Hi all,

I'm in charge of billing tenants for my company & I have recently explored the 'Mail Merge' function in Words to help me prepare invoices.
I managed to create the invoices but it's limited to 1 data row (in Excel) resulting in 1 page (in Word).
Therefore, I'll have many pages although all should go to the same tenant.

I was wondering will it be a complex thing to do if I wanted to 'merge' all the required lines into 1 same page for 1 same tenant, with has a unique identifier (which is the ID / Location).

Sample data & template are as per attached.
Really appreciate it if someone could help me out..many great thanks in advance!

Sample Data.xlsx
Sample Template.docx

Any help???

Hi DB, I myself have tried to do this before but failed as the functionality was not designed to allow you to do that. What you are trying to do really requires the use of a relational database like Access where you can then store the data in separate tables linked by common ID values and then create a query and report format for your invoices that will allow you to group the different billings for each recipient. The only work-around that I can see that would work is if you were to add some additional columns for the billing types and amounts before you then treat the tenant as a new record. So that would economise on the amount of paper to be printed out. I attach your samples with my modifications to illustrate what I mean. So that is all I can offer you unless someone else on this forum knows better?
Regards, Pius.

Thanks for the suggestion Pius, I guess I have to learn more about Microsoft Access..