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
Bookmarks