How to merge Excel chart for mass Word Mail Merge for employees

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hmboomer - 08 Jun 2006 15:29 GMT

I want to merge data from EXCEL and also
have a "customized" chart created. For example, in EXCEL
I have name, salary, benefit cost, etc. I want the letter to
be customized per name with a pie chart displaying their
salary and benefits.

Reply to this Message

Doug Robbins - Word MVP - 08 Jun 2006 20:02 GMT

See the "Merge with Chart" item under the "Special merges" section of fellow
MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

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

>I want to merge data from EXCEL and also
> have a "customized" chart created. For example, in EXCEL
> I have name, salary, benefit cost, etc. I want the letter to
> be customized per name with a pie chart displaying their
> salary and benefits.

Reply to this Message

hmboomer - 08 Jun 2006 22:59 GMT

I've been helping a co-worker trying to figure this out. Due to the volume
of employees we're dealing with, we've determined our best course of action
is VBA coding...ordered a book for additional guidance.

Thanks for the info. I was hoping with newer versions of Office out, there
may have been an easier way to achieve the goal.

Again, really appreciate the quick response!

Thanks!

> See the "Merge with Chart" item under the "Special merges" section of fellow
> MVP Cindy Meister's website at
[quoted text clipped - 6 lines]
> > be customized per name with a pie chart displaying their
> > salary and benefits.

Reply to this Message

John - 09 Jun 2006 22:08 GMT

Thank you for your sample word files, however when I run the doc I only get
one page in the results when there are 9 records in your source data doc.
How do I get all 9 pages in the results?

John

Reply to this Message