mail merging dynamic charts
 

I have set up a spreadsheet with a dynamic chart which I can operate
from a control box. Is there any way of using this in a mail merge
document so that as each page is printed the individual chart is
mailmerged. If not is there another way of doing this.
Essentially there are rows of data tracking progress of pupils and I
want to make this more visual but I do not want to have to create
hundreds of charts. The dynamic chart advice I have been given works
fine on the spreadsheet and I want to (if possible) take this over
intoa word document. Chips