Sequential numbering of tickets

[CanadaBc13]

I need to make tickets for an event and I used the business card template. I
needs sequential numering ont he tickets. I need to print 10 per page but if
I just do, page numbering, then it labels all of the tickets ont he first
page with a 1. HOw do I fiz this so that numbers 1-10 appeard ont he first
page on tickets. (I am using Publisher 2003)

 

[LVTravel]

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.

Hope this helps, let us know.

 

[Mary Sauer]

In addition to LVTravel's advice, 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.

 

[LVTravel]

Thanks Mary, forgot about that bug.

In addition to LVTravel's advice, 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.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

 

[aishida]

I have been trying this, but all of my coupons (8 on a page) merge with the
first number only. I don't have a "next field" option and I am printing about
1000 coupons. Any pointers on merging with multiple copies per page?

 

[Mary Sauer]

There is no *next field* in Publisher. What version Publisher are you using?

You can only have one coupon on your screen for the merge to be successful.
Print preview will show the same number on all coupons, this is a bug in
Publisher 2002-03.

Help here
http://office.microsoft.com/en-us/publisher/CH062524751033.aspx

You may have to change the batch size in the registry.
The Registry Fix
for changing the Mail Merge Batch Size
http://ed.mvps.org/Static.aspx?=Publisher/registryfix