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! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I get my invoice mailmerge to pagebreak by invoice #?
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/cindy...faq1.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/show...?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 "Ski Club" Ski Club @discussions.microsoft.com wrote in message ... 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! |
Reply |
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 |