Hi
I have a Word document and an Excel document for each of 21 counties in our state. The Word document contains language, data, and charts with the data, charts coming from the corresponding Excel file. I am looking for a way to create 1 Word for all 21 counties where the Word document pulls data, charts to display in it from the correct county spreadsheet triggered by some kind of merge field, etc. in the Word document representing the county?

Also, the data in the Excel file is not in 1 neat table. There are several groupings of data in the file that drive the charts and data from the document.

Any ideas at all?

Paul