Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I get my invoice mailmerge to pagebreak by invoice #?
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge multiple lines (invoice etc) | Mailmerge | |||
i need a invoice for a labour minus tax invoice | Microsoft Word Help | |||
Invoice | New Users | |||
Why will the invoice not print, only the word invoice | Microsoft Word Help | |||
Invoice Template with Autoupdate for Invoice Number | Microsoft Word Help |