financial statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

foxeddave - 27 Aug 2007 21:32 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 28 Aug 2007 04:22 GMT

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

Signature

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

>I have data in Excel in one row per outstanding invoice which includes
>client
[quoted text clipped - 6 lines]
> ie
> Just like a bank statement.

Reply to this Message

Rate this thread: