#1
|
|||
|
|||
Sequential Numbering on Tickets Multiple number Sequences
I've been printing tickets that require sequential numbering and have that working but I have some issues that are bigger then my knowledge.
I have a word document with a table of 6 exact cells on a full page table. In those cell areas I have been printing tickets with a list and a mail merge and updating labels. I call to an excel list of 1-2000 and then I generate all the pages through the Finish and Merge option. This all works perfect. I get 2000 individually numbered tickets to print...however...I then have six tickets printed on a page of paper with ticket numbers 1, 2, 3, 4, 5 ,6 then the next page has 7,8,9,10,11,12. This is fine but I then have to cut and stack these tickets in groups of six and at that point none of the numbering is sequential. The tickets are basically random. Any suggestions on the best way to split the 6 regions so that the top left region would be 1-335, then the middle top would be 336-670, Then the top right would be 671-1005, then bottom left would be 1006 - 1340, Then bottom middle would be 1341-1675, then the final bottom right region would be 1676-2010? So the first page of numbers and regions would look like this: 1 336 671 1006 1341 2011 The second page would look like this: 2 337 672 1007 1342 2012 The third page would look like this: 3 338 673 1008 1343 2013 Plus the bad news....I'm an artist not a programmer simple terms and suggestions would be GREATLY appreciated. |
#2
|
||||
|
||||
This could be done with a macro, but the code would need to be tailored to put the numbers where you need them. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Otherwise, you could, instead of a merge, use a page of labels with six SEQ fields set for different sequences and with an interval of 6. The first page would be your initial set of fields with numbering 1, 35, 69, 103, 137, and 171.
The first field would be { SEQ Ticket1 /r 1 /# "0000" }. The second would be { SEQ Ticket2 /r 35 /# "0000" } and so forth. Remember that the { } braces for fields cannot be typed. They must be inserted by Word using Insert > QuickParts > Field or Ctrl-F9. Labels are Word Tables. Create your first page, what you are using for a merge page now. Use the six SEQ fields instead of the Mail Merge field. Copy the entire table on the first page and paste it creating a second page. On the second page press Alt-F9 to toggle display of field codes. Change the fields to drop the /r switch, i.e. The first field on the second page would be { SEQ Ticket1 /# "0000" }. The second would be { SEQ Ticket2 /# "0000" } and so forth. Press Alt-F9 again to toggle back to field results. Then copy that page and paste until you have a total of 34 pages of tickets. Press Ctrl-A to select the entire document and press F9 to update the fields. You should have 2004 tickets numbered so you can cut them in sequential stacks. That is, the top stack would be numbered 1-34, the second stack numbered 35-68, and so forth. After you cut them, you can put the first set on top of the second, on top of the third... For larger numbers, increase the interval between each sequence and use that number of pages. What I suggested is based on 34 pages of 6 so the interval is 34. For each additional page of 6 you would increase that interval between the starting numbers by one. See Insert and Format Field Codes in Word Remember that the { } braces for fields cannot be typed. They must be inserted by Word using Insert > Field or Ctrl-F9. For more about Numbering in Microsoft Word |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sequential numbering across multiple docs | mslearner | Word | 18 | 06-12-2019 04:00 AM |
How do I do a Sequential Numbering? | gburya | Word VBA | 26 | 07-04-2017 03:29 PM |
How to keep sequential numbering with multiple pages | GeneOliver | PowerPoint | 1 | 10-01-2012 11:26 PM |
tickets numbering | frenchyinpaddyland | Publisher | 0 | 04-27-2012 01:02 PM |
Sequential Page Numbering of Multiple Word Docs | bobmard | Word | 8 | 08-24-2011 08:51 AM |