WAY to make tracking /order numbers for cut stacks !

J

james

IS there ANYONE who knows how to make a formula or a process that can make
tracking numbers 4 to a page down not across a cut 1/4 stack ?
That means once i cut a pile of 8.5x11 sheets in 4 quarters.. each stack is
numericly in order .

Because so far i been posting this question in MS Office help ..NOT 1 soul
CAN figure this out !! WHAT gives??
I realize that some volenteer ..and are not payed for helping..and this may
be some part of the reason of discrepency.
 
E

Ed Bennett

james said:
IS there ANYONE who knows how to make a formula or a process that can make
tracking numbers 4 to a page down not across a cut 1/4 stack ?
That means once i cut a pile of 8.5x11 sheets in 4 quarters.. each stack is
numericly in order .

The easiest way would be to set up your sheet of labels so you can see 4
at once when editing in Publisher (as opposed to the usual 1 for merged
labels).

Then set up your merge source (easiest in Excel for this purpose) to
have 4 columns. For 100 labels, these would run from 1 - 25, 26 - 50, 51
- 75, 76 - 100 respectively.

Insert one column in each label on your page.
 
J

james

OK this sounds like it has potential here that i can understand well enough. Ty
Though i do know how to use merge etc for the basic.. i do recognize my lack
of know ing how to create four columns to insert into each part/label;
moreover this is the surrounding issue i am up against, of not knowing a
formula method or proceedure to create such a list, thereto merging it into
my project.
 
J

james

OK wile i was posting my 1st reply i did quick check in excel on mail merge
and its there in help, so i just made a column of numbers and repeated it
(incrementaly) 4 x ,the same way..so simple, just make a list in each colum
and name it above the list (x 4) and save the file; the rest ,Mspublisher
handled the same way in its wizzard..and in my mock attempt to have the full
8.5x11 sheet visible divided in 4 , as ya said, i put each column in each
quarter, printed it out and presto GOT IT ..
only 1 thing left.. on the print out the smallest numbers print first and
are on the bottom..so i figure i can go into excel to reverse the order
(somehow) of each columned list before i save it..!?

THANK You very impressive !
 
E

Ed Bennett

james said:
only 1 thing left.. on the print out the smallest numbers print first and
are on the bottom..so i figure i can go into excel to reverse the order
(somehow) of each columned list before i save it..!?

You could do that (the sort buttons are on the toolbar), or you could
sort the list when it arrives into Publisher (options are in the Merge
Wizard somewhere).

Thanks for letting us know it worked :)
 
L

LVTravel

James, actually I posted the way to do it before when you posted in the
other newsgroup. Since you didn't specify originally how the project was
laid out I gave initially confusing advice but it hit on exactly what you
wanted to do. Here's the directions rewritten in a more readable format.

The data for the merge, in this case in Excel, is 4 labeled columns (Label A
in A1, B in B1, C in C1 and D in D1), with the beginning number at the top
of the first column (starting in A2), then ending number of "tracking
numbers" plus one as the beginning number for column 2 (beginning in B2),
the ending number from column 2 plus one for column 3(beginning in C2) and
the ending number for column 3 plus one as the beginning number for column 4
(beginning in D2). If column A had 1 - 50 in it the first number in column
B would be 51, C would be 101 and D would be 151.

The page layout in Publisher needs to show the four-up layout on a full size
sheet of paper. (Four identical forms laid out top to bottom. Create the
forms with the proper space for the numbers and then save the document just
in case something goes wrong.) Do a Mail Merge on this full sheet of forms.
Select the Excel spreadsheet you created and saved earlier as your data
source. In step 3 of 5 in the Mail and Catalog Merge wizard, click on the T
next to the column A label and it will appear on the document. Position and
resize the box, select the default font, etc and when satisfied with that
one, click outside the box to turn off the drag handles. Click the T next
to the next label. Position and arrange the second one on the sheet for the
second form and when done click outside the box to turn off it's drag
handles. Continue for the remaining two forms on the page.

When done save your work and then click Next to Preview your Publication.
Once the way you want it, print to your heart's content.

Hope this explanation is better and helps more than the first.
 
J

james

THANK you
i can understand you !


Ed Bennett said:
You could do that (the sort buttons are on the toolbar), or you could
sort the list when it arrives into Publisher (options are in the Merge
Wizard somewhere).

Thanks for letting us know it worked :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top