OK. I'll outline the three (or four) basic approaches that
can be used. One of them requires macro code; the other
three are really only do-able using macros, but could be
done manually:

1. Create a separate pie chart for each record in Excel. Add
a merge field to the data source that contains the
corresponding NAME for each chart sheet. Use this merge
field in a LINK field to link the chart across for the
merge. Merge to a new document, Ctrl+A, then F9 to update
the LINK fields.

2. The approach you tried already, linking a table in Word
to an MS Graph chart. But then you have to manually "view"
each record and print that out. Executing the mail merge
won't work because the bookmark that links the table into
the chart is lost.

3. Similar to (2), but you create the charts AFTER the mail
merge.

4. In Word 2002/2003 there's a VBA-thing that would let you
create the charts on-the-fly, using either a table in the
document, or data from an outside source.

Of these, I think only (2) would be acceptable to do
manually. Whether you'd actually want to do it would depend
on how many records you'd have to cycle through.

If you're not in a hurry, I'm planning to work up (4) for a
book. I just don't know when I'll get to it (over the
weekend, I hope!)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail