Word Mail Merge & Excel

I'm not sure where to go for help. I'm under pressure to help a collegue but don't have the skill. I've been here for myself and gotten wonderful help so I thought I'd try this.

They have an excel data structure of client records for this non-profit. They are trying to collect on a lot of late payments that were promised to them. I'm simply trying to help.

If there is somewhere else I should go please advice me of such. Thanks thanks thanks.....
Mike O

Excel File
Address First Last Item Purchase
1234 Street Bill Johnson XYZ $4.50
1234 Street Bill Johnson RST $5.60
1234 Street Bill Johnson ABC $3.50
3344 Lane Wanda Wilson XYZ $4.50
5789 Drive Jim Franklin NOP $0.99
5789 Drive Jim Franklin EFG $5.89


I'd like to have all the individual records and the total in three Windows word mail merge letters. I do not have Query or Access or understand VBA.

Dear Bill,

As of today you owe $13.60 for:
XYZ $4.50
RST $5.60
ABC $3.50


----------------------------------------------------------------------------------

Dear Wanda,

As of today you owe $4.50 for
XYZ $4.50

----------------------------------------------------------------------------------

Dear Jim,

As of today you owe $6.98 for
NOP $0.99
EFG $5.89

Hi there

This is a special type of mail-merge, which can be done in various ways.

One method is to use special merge fields, and this is explained very well at http://support.microsoft.com/?kbid=211303

If you need help in applying the example, please post again.

Regards
Mike

Originally Posted by Mikeopolo

Hi there

This is a special type of mail-merge, which can be done in various ways.

One method is to use special merge fields, and this is explained very well at http://support.microsoft.com/?kbid=211303

If you need help in applying the example, please post again.

Regards
Mike

I'll let you know