I have client lists in Excel 2007, and want to send them a letter in Word 2007. Some of the merge data is multiple account information. I'd like to merge it as:

Acct. type: Acct. No. Tax Status Cost

My data in excel has multiple accounts for any single client:

Client 1 Acct. type Acct. No. Tax Status Cost
Client A X 1111111 Q $x
Client A Y 2222222 N $y
Clent A Z 3333333 Q $z
Client B X 4444444 N $a
Client B Y 5555555 Q $b


I also have a worksheet with each client's name and address to be merged.
How do I get the different account data from excel to print in each client's single letter?
I have tried Vlookup but only one of the accounts will come through to the address worksheet. (Mail merge requires it all to be on one sheet).

The client lists are long, and I don't want to go through and cut and paste into the horizontal so I can have the Word Mail Merge grap each piece of data and put it in the letter. Any help?

Thanks

Jlynch