How do I create individualized charts in Word from an Excel merge.

[Jim]

I'm creating a mail merge in Word, using a large Excel data source. The file
contains multiple names, with various associated data.
I want to create an individualized chart for each name, using data
associated with their name in the Excel data source file. One customized
chart per name, merged into the Word document.

Any help you can provide is greately appreciated. Thanks.
Jim

 

[Cindy M -WordMVP-]

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

I'm creating a mail merge in Word, using a large Excel data source. The file
contains multiple names, with various associated data.
I want to create an individualized chart for each name, using data
associated with their name in the Excel data source file. One customized
chart per name, merged into the Word document.

1. Do a google search on: Meister mail merge chart Excel

You'll turn up any number of posts describing the various approaches.

2. In the Mail Merge FAQ on my website you'll find a sample document with VBA
code for ONE of four methods.

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