how to create variable pie charts using mail merge

[sc]

Running version 2002 of Word, Excel etc

Have a mail merge to process, 5000 records, each record has client's name
and address info along with sales info for each client by quarter.

Each record has the following:

name, address, quarter 1, quarter 2, quarter 3, quarter 4

What would be the best way (which application to use) to set up a mail merge
document where we print the client's info along with a pie chart of the 4
quarters? Of course the pie chart and client info will be different from
record to record.

Thanks

 

[Bob Buckland ?:-\)]

Hi S.C.,

You may want to use the link below to also post this in the MS Word Mailmerge discussion group.

===========
Running version 2002 of Word, Excel etc

Have a mail merge to process, 5000 records, each record has client's name
and address info along with sales info for each client by quarter.

Each record has the following:

name, address, quarter 1, quarter 2, quarter 3, quarter 4

What would be the best way (which application to use) to set up a mail merge
document where we print the client's info along with a pie chart of the 4
quarters? Of course the pie chart and client info will be different from
record to record.

Thanks>>
--
Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends*

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.mailmerge.fields
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.word.mailmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[crldatasolution]

Was this issue resolved? I'm having the same problem. I want to create
different pie chart for each record in my mail merge. I tried usin
Cindy Meister's code, but it errors out

of.DoVerb wdOLEVerbInPlaceActivat

Thank you