I have tried using the fourth method that Cindy suggests, but I am having
problems with the VB code, as I am not well-versed in it. I find the
instructions hard to follow without VB knowledge. In the basic module it asks
for a filepath. I put mine in (H:\My Documents\Benefits\ChartDataDoc) and I
get a compile error message that says "Expected: line number or label or
statement or end of statement." Can you tell me what I'm doing wrong?


"Peter Jamieson" wrote:

I'd have a look at the "Merge with Chart"/"Mail Merge to a chart"
section on Condy Meister's website at

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

Peter Jamieson

http://tips.pjmsn.me.uk

Stormy wrote:
Hi,

I have an Excel Sheet with 1000 lines of data. Some of the data is text
(people's names etc) and some is numbers. I'd like to run a mail merge to
Word that pulls some of the data across as it is - such as the names - but
also creates a pie chart for each line using the other data. Is this possible?

Thanks