Chart in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KornDog - 28 Oct 2006 03:46 GMT

I have Office 2000 and need to create a mail merge to create 400+ reports.
The problem I am having is each report has two chart that should appear based
on information in the excel data sheet.

I have followed the information from Cindy's Meister's website and cannot
get it to work in Office 2000.

Reply to this Message

Doug Robbins - Word MVP - 28 Oct 2006 07:59 GMT

You should advise in full detail just what you have done. Just the say that
you "have followed the information from Cindy's (sic} Meister's website and
cannot get it to work" does not help anyone tell where you have gone off the
rails.

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 have Office 2000 and need to create a mail merge to create 400+ reports.
> The problem I am having is each report has two chart that should appear
[quoted text clipped - 3 lines]
> I have followed the information from Cindy's Meister's website and cannot
> get it to work in Office 2000.

Reply to this Message

KornDog - 29 Oct 2006 08:30 GMT

Doug, thanks for responding so quickly. Sorry for being so vague. Cindy
Meister's website, referred to in several posting on this topic, indicates
four ways to create mail merges with charts. The first three are all manual
processes. The last one uses features of Office 2002 to automate charts on
the fly. This is the option I tried.

If I run this code on a PC with Office 2002 it works perfectly. But when I
run it on Office 2000 it does not ever execute the class module. I want to
know if it is possible to create a mail merge file that produces charts
within a mail merge letter/report on the fly using Office 2000.

> You should advise in full detail just what you have done. Just the say that
> you "have followed the information from Cindy's (sic} Meister's website and
[quoted text clipped - 8 lines]
> > I have followed the information from Cindy's Meister's website and cannot
> > get it to work in Office 2000.

Reply to this Message

Doug Robbins - Word MVP - 29 Oct 2006 11:35 GMT

As far as I know, the events that execute the class module were only
introduced with Office 2002.

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

> Doug, thanks for responding so quickly. Sorry for being so vague. Cindy
> Meister's website, referred to in several posting on this topic, indicates
[quoted text clipped - 28 lines]
>> > cannot
>> > get it to work in Office 2000.

Reply to this Message

Cindy M. - 01 Nov 2006 16:52 GMT

Hi =?Utf-8?B?S29ybkRvZw==?=,

> Doug, thanks for responding so quickly. Sorry for being so vague. Cindy
> Meister's website, referred to in several posting on this topic, indicates
[quoted text clipped - 6 lines]
> know if it is possible to create a mail merge file that produces charts
> within a mail merge letter/report on the fly using Office 2000.

Doug is correct, the events used aren't available in Word 2000 and earlier.
You'd have to modify the approach to add the charts to the mail merge result
document. Actually, given the level of complexity, I'd probably avoid mail merge
completely and automate the entire report generation, especially if you need 400
separate reports (files).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message