Mail Merge with EXCEL Chart

[Kim]

I am trying to create a Word document using EXCEL as the
source document. I want to merge data from EXCEL and also
have a "customized" chart created. For example, in EXCEL
I have name, salary, benefit cost. I want the letter to
be customized per name with a pie chart displaying their
salary and benefits.

Any ideas?

Thanks

Kim

 

[Cindy M -WordMVP-]

Hi Kim,

You should find an article on this in the Mail Merge FAQ on
my website.

I am trying to create a Word document using EXCEL as the
source document. I want to merge data from EXCEL and also
have a "customized" chart created. For example, in EXCEL
I have name, salary, benefit cost. I want the letter to
be customized per name with a pie chart displaying their
salary and benefits.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
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

 

[Richard A]

Cindy
I am trying to develop VBA to automate your first example.
"Create a chart for each record in Excel. Add a column to the data table and
enter the name of the appropriate chart for each record. Use this merge field
in LINK field in the mail merge document"
Can you direct me to where I might find help.
Thanks
Richard

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?UmljaGFyZCBB?=,

I am trying to develop VBA to automate your first example.
"Create a chart for each record in Excel. Add a column to the data table and
enter the name of the appropriate chart for each record. Use this merge field
in LINK field in the mail merge document"
Can you direct me to where I might find help.

As far as I know, I'm the only help around... Where are you stuck?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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