Your data is structured quite nicely but I can't see how it could be used to build a mail merge report in a single Word document.

I think you can use a many-to-one type merge for one section of the report but needing to start multiple times with each a new filter/output fields is problematic.

A Word-centric method using a 'subreport' concept would be to create a shell document and produce separate mail merge output docs for each of the sections. You can then use IncludeText fields to link to those separate documents. This is probably too labour intensive to use as a realistic option.

I would say that this is a job that Microsoft Access is better suited for with a report comprised of sub-reports.

You could also create a macro to do it all in a single Word document. This macro could create a recordset from the input data and then loop through that to build the various sections.



Do any of those options appeal?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

I somewhat suspected that this wasn't an easy straightforward project. Thank you so much for your fast response and providing the suggested options, but for the limited use I don't see that there would be a return on my time invested.

I can use the excel data to create the list manually. Which in itself is a step ahead of where I was. Prior to using this application software the data was gathered manually at personal interviews. I then went page by page of interview results and compiled the master list. Now I can compile the list manually from the data in the spreadsheet without having to conduct the 50 personal interviews.

I may revisit this when I am bored just because it is a bit of a challenge and I always like to win! :-)