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.