Yeah, the mail merge will not work because the all data is not neatly organized in 1 table. I can embed the Excel charts in the Word documents, but was really looking for something to automate.

I was thinking of using the vlookup function, but this also seems to require 1 neat table. Anyone have experience with either this or a similar approach in this situation?

Paul