[EDBERN1]

I have used Cindy Meister's macros to create a chart in a mail merge. It
works perfectly. The problem is that I need to create multiple charts for
each row of data (multiple charts on each letter). Can anyone tell me how to
modify the macros to accomplish this? If not, does anyone know another
method to accomplish this? Thank you.

[Doug Robbins - Word MVP]

Post back if you are not able to get Peter's method to work as I use a
method that is different from that proposed by Cindy.

Basically, it is a "roll-your-own" equivalent to mailmerge that uses
docvariables in place of merge fields and charts that are linked from Excel
and when the code is run, a new document is created for each record with the
values of the variables in that document being set to the values of the data
items from the current record and in Excel, the data used for each chart is
set to that for the current Excel record so that the charts in Excel are
updated and also in the Word document via those there being linked to those
in Excel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"EDBERN1" wrote in message
...
I have used Cindy Meister's macros to create a chart in a mail merge. It
works perfectly. The problem is that I need to create multiple charts for
each row of data (multiple charts on each letter). Can anyone tell me how
to
modify the macros to accomplish this? If not, does anyone know another
method to accomplish this? Thank you.