Word Mailmerge issue

[JP SIngh]

Hi All

I have an excel worksheet which I use as my data source in my mailmerge

The information in the worksheet is about company and the contracts
outstanding with them. For example

Company Contract

TQA AAAAAA
HGP 78444444
HGP 88848844
HGP 77777777

These contract is what we need to write to the company about in our mail
document.

If there is a company for example TQA which only has 1 contract outstanding
there is no problem mailmerge will be print one letter for them.

But for company like HGP i would like to print all the contracts on one
single letter rather than create 3 different letters.

I would want the letter generated to look like the following

HPA

We have the following contracts outstanding

AAAAAA
78444444
88848844
77777777

Can this be done using mailmerge or VBA or combine the two together.

 

[Greg]

JP,

You should be able to do this with the method listed here:

http://support.microsoft.com/?kbid=105888

 

[JP SIngh]

Cheers Greg

Can you also add how to apply this to my document?

I tried copying and pasting but the fields don't work then.

Using office 2000


thanks

 

[Cindy M -WordMVP-]

Hi JP,

Can you also add how to apply this to my document?

I tried copying and pasting but the fields don't work then.

Fields described in a text article can't just be copied and
pasted. The { brackets } need to be generated by pressing
Ctrl+F9. Alt+F9 lets you toggle between the field codes and
field results. Does that get you a bit further?

Note that you'll find another approach described in the
discussion on this topic in the Special Merges section of my
website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
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