Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2013, 09:07 AM
skitchen skitchen is offline Sequential Numbering on Tickets Multiple number Sequences Windows 7 64bit Sequential Numbering on Tickets Multiple number Sequences Office 2010 64bit
Novice
Sequential Numbering on Tickets Multiple number Sequences
 
Join Date: Sep 2013
Posts: 1
skitchen is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 10-01-2013, 05:46 AM
macropod's Avatar
macropod macropod is offline Sequential Numbering on Tickets Multiple number Sequences Windows 7 32bit Sequential Numbering on Tickets Multiple number Sequences Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 10-01-2013, 06:41 AM
Charles Kenyon Charles Kenyon is offline Sequential Numbering on Tickets Multiple number Sequences Windows Vista Sequential Numbering on Tickets Multiple number Sequences Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequential Numbering on Tickets Multiple number Sequences Sequential numbering across multiple docs mslearner Word 18 06-12-2019 04:00 AM
Sequential Numbering on Tickets Multiple number Sequences How do I do a Sequential Numbering? gburya Word VBA 26 07-04-2017 03:29 PM
Sequential Numbering on Tickets Multiple number Sequences 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 Numbering on Tickets Multiple number Sequences Sequential Page Numbering of Multiple Word Docs bobmard Word 8 08-24-2011 08:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft