autonumber in pages of tickets

[Bowden]

There has to be a way to get autonumber to work in creating pages of
tickets with continuous numbering - I tried Publisher but found nothing
there - tried labels but couldn't get anything but continuous #1.
Ideas?

[Suzanne S. Barnhill]

See "Sequentially numbering multiple copies of single document using a
macro" at
http://www.mvps.org/word/FAQs/MacrosVBA/NumberCopiesOf1Doc.htm

--
Suzanne S. Barnhill
Microsoft Word MVP
Words into Type
Fairhope, AL USA

Bowden <abow...@televar.com> wrote in message
news:3AECABC1...@televar.com...

[Bowden]

Thanks - I'll give that a try. I thought there might be a FAQ on this but
couldn't find it.

[Bowden]

I gave that a try, but didn't realize it would send it immediately to printer
- after clearing that!! what changes would I have to make to get this to
repeat across the labels within the page - I have 10 tickets on a page (using
labels) and those that printed (before I could stop it!) came out with just
the first label numbered consecutively one/page.

[Graham Mayor]

While the other replies in the group concern Word, this is quite simple to
do with Publisher, but requires a tad of lateral thinking - and as Publisher
is a better tool for producing tickets (or labels) with constant information
and or graphics then I would recommend you stick with it.

As you have Publisher, chances are you have Excel too. You need to use this
to create a number list - which itself is child's play. (You could use the
same technique for Word)
In cell A1 enter Ticket_number
In cell A2, put the first number of the ticket sequence. You can even
include letters eg ABC123.
In the cell A3 put the second number in the sequence e.g. ABC124
Select the two number cells, and drag the handle at bottom right down the
column to produce as many new cells as ticket numbers. Save the Excel file
and close Excel
In Publisher, Mail Merge > Open Data Source > Merge Information From Another
Type Of File > Pick the filename of the Excel file. Confirm you want to use
the first row as field name and on the prompt for the sheet number enter
sheet1. Add the field to your ticket merge print.

--

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor <gma...@eidosnet.co.uk>
The five ages of man:
Lager.. Aga .. Viagra .. Saga .. Gaga
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

"Bowden" <abow...@televar.com> wrote in message
news:3AECABC1...@televar.com...

[Suzanne S. Barnhill]

I'm sorry. I'm not the author of this macro, but it was my understanding
that it was set up to do things like tickets. What you might find more
satisfactory then, is to fall back on the method most people used before
this macro was posted.

1. Create one page of tickets as a mail merge main document.

2. Create a data source in Excel, using AutoFill to drag and fill cells with
as many ticket numbers as you need. Excel is well suited for this because it
will imitate whatever number format you begin with.

3. Insert the ticket number as a merge field referring to the Excel data
table.

4. Run the merge (to new document, NOT the printer!).

Alternatively, you could use a SEQ field for the ticket numbers, but you'd
have to copy/paste as many pages as needed to get the required number of
tickets.

--
Suzanne S. Barnhill
Microsoft Word MVP
Words into Type
Fairhope, AL USA

Bowden <abow...@televar.com> wrote in message

news:3AECF773...@televar.com...