Hi Jennifer,Hey Guys! been a good 18 years and I am facing this exact same problem, is there any easy solution for this now? would be very grateful!
You'd need to ask this in an Excel group; I'd be skeptical,
too :-)
FWIW, the charts can be in separate workbooks. In this case,
you'd need a merge field in the LINK field for the workbook
name (try to keep the same path, otherwise things get much
too complicated), as well as one for the chart name. Two
additional fields in the data source, rather than one.
Hi -- I am trying to do the same thing: use Excel as my
data source, bringing over text, numbers AND (hopefully)
graphs. I've been reading through this Newsgroup and found
the very helpful posts from Cindy.
However, I have a concern: I will have 750 records for
this mail merge. Each record has about 80 fields of data
PLUS 3 charts per record. Cindy's method #1 suggests
creating all the charts in Excel as separate sheets and
then pulling them over. 750x3=2,250 charts, thus 2,250
separate sheets. Is this feasible for Excel? (I'm not an
Excel power user!)
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 293 |
Nodes: | 16 (2 / 14) |
Uptime: | 219:20:22 |
Calls: | 6,621 |
Calls today: | 3 |
Files: | 12,171 |
Messages: | 5,317,854 |