I am trying to put together a letter that takes data from a large table of real estate agents that have tenants who have received financial assistance for their Bond.
I have a letter that is the first page, that needs to include the field:
Then a table on the 2nd page that needs to include the fields:
Property Street Address
Property Bond Number
I have tried to use formulas to get this to work, but I can only get a separate letter for each landlord and each tenant.
I need a letter for each landlord with a list of their tenants in each letter - so some may have one tenant and some may have twenty tenants.
Any help would be greatly appreciated.
I've attached the letter (basic mail merge only) and the file I've been using of test data.
Simply run the macro in the attached workbook. I have added an option to print each sheet if you want. A simple mail merge with word can produce the letters