Link for mail merge help not working

[Nancy]

Hello, on the helpful site you give out : (MVP Cindy Meister's website):
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic...

....it has a link to go to "know how" but its not working:
http://www.knowhow.com/Guides/DatabaseInfo/DatabaseInfo.htm

Any other suggestions to find this info? Thank you!

 

[Doug Robbins - Word MVP]

I can't find the specific link that you mention on that page, though there
is a different one

http://www.knowhow.com/Guides/CompoundMerges/CompoundMeger.htm

on that page that I know no longer works.

Perhaps if you tell us what it is that you need help with, we may be able to
provide it.

 

[Nancy]

Hello Doug, thanks for responding. I am trying to do a mail merge from excel
into word that adds an individual pie chart (pre-calculates) for each person
into the mail merge letter. The quantity of people is large (4500) so it
would be hard to do individually. I thought that the suggestion (number 2) on
Cindy's website sounded like it may help, although the link that it tells you
how to do it was the one I wanted to read. I have searched the discussion
groups to see what other people have done, but most just refer you to Cindy's
website for this. If you have any other suggestions that would be great.
Thanks again, Nancy

 

[Doug Robbins - Word MVP]

Hi Nancy,

For that method, you have to preview the merge data, one record at a time,
and print as you go, which is probably not feasible if you want to do it for
4,500 people, though as Cindy says, the process could be automated so that
the preview and printing could be done automatically.

If you are using Word XP or later, I would recommend that you investigate
the fourth method - "Creating the charts on the fly as the mailmerge
executes in the main merge document"

However, to learn a bit about the use of database fields, the following
links may help:

http://www.bettersolutions.com/word/WOO733/LA811111611.htm

http://office.microsoft.com/en-us/word/HP051862061033.aspx

http://office.microsoft.com/en-us/word/HP051901661033.aspx

For the last one, be sure to click on the Show All.

--
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

 

[Nancy]

Hi Doug,

Thank you for all of the additional suggestions, will certainly try them
and do much research! I have Word 2003. I am sure something is bound to
work. Thanks again,

Nancy

 

[Nancy]

Hi Doug, I am trying the 4th method, and got stuck on the following steps:

1) insert a normal module and a class module into the main merge doc and
copy cooresponding code (where can I find these modules?)
2) go to tools/references in Visual Basic Editor (I do not think I have
VBE?!), can it still work? Where do I get VBE at?

Thanks!

 

[Nancy]

Sorry - I found this info finally, however, I do not know what the "
cooressponding code" is. Any ideas?

 

[Doug Robbins - Word MVP]

The code is in the modules in the MailMergePieChartLetter.doc file

--
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

 

[Nancy]

Thanks, really appreciate the support....!!

The code is in the modules in the MailMergePieChartLetter.doc file

--
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

 

[Shashi]

Hi ,

I used the 4th mehod using the vba. When i run the vba code i get only one
record merged . I would like to create the documents with all the records.
As we have 9 records in the example file.

Any help is appreciated.

SHashi

 

[Doug Robbins - Word MVP]

If you read through this thread, you will see where it is said:

--
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