It would be easier to help you if you copied and pasted into a message the
whole routine, indicating which line produces the error message.
--
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
"IlliniGirl" wrote in message
...
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