How to merge a excel data in a word file with page breaks

[Jorge]

Hi everyone,

I have a excel data sheet with the open invoices (invoices not paid
yet) from my customers.
Each line on my sheet have this fields:

CUSTOMER NUMBER
CUSTOMER NAME
CUSTOMER ADRESS
INVOICE NUMBER
INVOICE DATE
INVOICE AMMOUNT

Some customers have more than one open invoice.

I'd like to create a letter in Word with:


+ + + + +


CUSTOMER NAME
CUSTOMER ADRESS

Dear Customer,

Please pay the follow open invoices (I will be not rude, but is a
example)

INVOICE # - DUE DATE - INVOICE AMMOUNT -

Thank you,

+ + + + + +

I'd like to:

1) for each customer, merge only the lines with the related invoices
2) make a sub-total for field INVOICE AMMOUNT
3) make a page break when the CUSTOMER NUMBER change in the excel data
sheet.

In fact, I'd like to use the subtotal function/formula available in
Excel, adding in the header the customer name/address.

Thank you

 

[Doug Robbins - Word MVP]

See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.


--
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, originally posted via msnews.microsoft.com