How do I get my invoice mailmerge to pagebreak by invoice #?

[Ski Club]

I am using Excell 2003 and Word 2003. Each row of my Excel inventory
includes a field called "SellerID" which we use as the invoice number. It is
created from the first three characters of the seller's last name, then a
hypen, then the last four digits of the seller's phone number. Example: for
John Smith at 231-456-7890 it is SMI-7890. Each row in the Excel inventory
sheet is an item: Row 1 is a pair of skis, row 2 is a snowboard, etc. On
the template from Office Online for Word(Service Invoice, Sales Invoice/Blue
Gradient Design for Word 2000 or Later with 4 stars, 32610 votes), every row
after the first has "Nextrecord" before the mergefield "ITEM." When I put
the Seller ID as the mergefield "invoice number," I still get other sellers'
inventory on the same page as the SELLER ID printed; my invoice is just
printing all sequential rows from the inventory, independent of the seller's
ID number. In a nutshell, the invoice is not page breaking by Invoice number.
I know I'm probably missing something easy, but I've wracked my brain for
hours. Thanks!

 

[Doug Robbins - Word MVP]

Sounds like you are probably trying to perform 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 website

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

or take a look at the tutorial on this, with working field codes and a
sample Excel data source, that was created by fellow MVP, Macropod at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107


--
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