Getting a Chart to use merge Information

[BobSullivan]

I want to create a merged word document, merging employee information into it. As part of the process, I'd like to show a pie chart that shows each employee's breakdown of Salaries, Retirement, Deferred comp, etc. I have this information in an Excel Spreadsheet. I'd like to create a word letter for each employee. How do I put a chart in a letter so that the chart will used the merged information, creating a unique chart for each employee letter?

Thanks

Bob Sullivan
Elverson, PA

[HansV]

Welcome to Eileen's Lounge!

There is no built-in support for this in Word's mail merge. Cindy Meister describes some workarounds, with a downloadable file with VBA code to automate charts in a mail merge, in the section titled 'Mail merge to a chart' in her Mail Merge FAQ.