Serial numbers in Publisher 2003

[D.Duck]

I have lost my instructions for adding serial numbers to tickets I'm
printing on ticket stock in Publisher 2003. As I recall it used mail merge
and an Excel spread sheet with the numbers to serialize.

Can someone help me locate this instruction?

Thanks.

 

[LVTravel]

I have lost my instructions for adding serial numbers to tickets I'm
printing on ticket stock in Publisher 2003. As I recall it used mail
merge and an Excel spread sheet with the numbers to serialize.

Can someone help me locate this instruction?

Thanks.

You do a mail merge using a source file with all the numbers you need on it.
When it merges it will pull the numbers one at a time for each ticket. See
Mail Merge in help to assist you in setting it up. It is relatively easy
but the first time there is a bit of a learning curve.

Set up the merge data first (I use Excel) to create the data file. In cell
A1 type in your first ticket number then hold the Ctrl key down and then
drag the small square on the bottom right of that cell's outline down until
you get all the numbers you need for your ticket. (If you should let go of
the mouse button too soon, simply grab the new small square on the last cell
and continue to drag with the Ctrl key held.

Save the Excel file and then create your ticket file in Publisher and then
complete your merge.

Be aware when you print preview in Publisher 2003 all the cards will have
the same number. This is a Publisher bug. If you are unsure print a test
from the print dialogue. (Again, Thanks Mary.

This also may help
http://office.microsoft.com/en-us/publisher/HA011039741033.aspx?pid=CL100632931033

 

[D.Duck]

You do a mail merge using a source file with all the numbers you need on
it. When it merges it will pull the numbers one at a time for each ticket.
See Mail Merge in help to assist you in setting it up. It is relatively
easy but the first time there is a bit of a learning curve.

Set up the merge data first (I use Excel) to create the data file. In
cell A1 type in your first ticket number then hold the Ctrl key down and
then drag the small square on the bottom right of that cell's outline down
until you get all the numbers you need for your ticket. (If you should let
go of the mouse button too soon, simply grab the new small square on the
last cell and continue to drag with the Ctrl key held.

Save the Excel file and then create your ticket file in Publisher and then
complete your merge.

Be aware when you print preview in Publisher 2003 all the cards will have
the same number. This is a Publisher bug. If you are unsure print a test
from the print dialogue. (Again, Thanks Mary.

This also may help
http://office.microsoft.com/en-us/publisher/HA011039741033.aspx?pid=CL100632931033

Thanks, just the information I was looking for.