Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
financial statement
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
financial statement
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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;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 "foxeddave" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Financial responsibilty letters, for,? | Microsoft Word Help | |||
which statement right , question is Choose the correct statement? | Microsoft Word Help | |||
which statement right , question isChoose the correct statement? | Microsoft Word Help | |||
financial tables in Word | Tables | |||
financial statements | Microsoft Word Help |