Set up Sequential number template

[HB]

Please help with this challenge ....

Need to create a template to create a sheet o address labels with automatic
sequential numbers. Tired of typing indivisual numbers and would like the
computer to help with the task.

End product is a sheet of AVERY return address labels 5167 that start at
09000001 and go up sequentially. 09000002, 09000003, 09000004, 09000005
.......

2nd part of this challenge is that after the labels are printed from
09000001 through 09000040. The numbers need to progress to 09000041 through
09000080 on a second page which will not be required the same day. Day one,
employee opens a file and produces a sheet of labels 1-40. Day two, any
other employee opend the file and produces a new sheet of labels that starts
where the last one left off.

The numbers are for labels on file folders. The labels need to increase
from 09000001 through however many folders need to be labeled in 2009. Then
in 2010 the labels start over at 10000001.

 

[Mary Sauer]

http://www.gmayor.com/Numbered_labels.htm

 

[Graham Mayor]

See http://www.gmayor.com/Numbered_labels.htm and the add-ins linked from
that page + some other methods there that can be modified to your individual
requirement - though the add-in will do what you want. Set the label text
to 09## (next year 10##) and set the format to 6 zeros.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Robert M. Franz (RMF)]

Hello HB

Need to create a template to create a sheet o address labels with automatic
sequential numbers. Tired of typing indivisual numbers and would like the
computer to help with the task.

End product is a sheet of AVERY return address labels 5167 that start at
09000001 and go up sequentially. 09000002, 09000003, 09000004, 09000005
......

2nd part of this challenge is that after the labels are printed from
09000001 through 09000040. The numbers need to progress to 09000041 through
09000080 on a second page which will not be required the same day. Day one,
employee opens a file and produces a sheet of labels 1-40. Day two, any
other employee opend the file and produces a new sheet of labels that starts
where the last one left off.

The numbers are for labels on file folders. The labels need to increase
from 09000001 through however many folders need to be labeled in 2009. Then
in 2010 the labels start over at 10000001.

there are a couple of different approaches here:

Creating sequentially numbered documents (such as invoices, by Doug Robbins)
http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm

Sequentially numbering multiple copies of single document using a macro
(by Doug Robbins)
http://word.mvps.org/faqs/macrosvba/NumberCopiesOf1Doc.htm

Sequentially numbering multiple copies of single document using a
mailmerge (by Dave Rado)
http://word.mvps.org/faqs/MailMerge/NumberCopiesOfDocMMerge.htm

HTH
Robert