financial statement

[foxeddave]

I have data in Excel in one row per outstanding invoice which includes client
name. Some owe 1 invoice others 3 or more. i.e.
Fred £200
Fred £350
John £100
So if I merge from excel I get 1 page perline, what I need is one page per
client with all outstanding items for that client on the appropiate page ie
Just like a bank statement.

 

[Doug Robbins - Word MVP]

That amounts to a "multiple items per condition (=key field)" mailmerge
which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP