printing labels in a number sequence

roger howland

unread,

Jul 15, 2003, 11:35:37 PM7/15/03

to

I am stuck.

I am using an Avery type 5267 mailing label.

I need to make labels in sequence, like a serial number.
The first 6 characters are alpha, and the last 7 are
numeric... like this.
GKFVB5261435, GKFVB5261436, GKFVB5261437...
I need 1,000 of these

Is there a 'sequencer' in Word XP? Or can I set up a
spreadsheet to create the numbers and then print them on a
sheet of labels?

Where do I go?
Who do I call?
What can I do?

I appreciate any suggestions you may be able to offer

Thanks,

Roger

Doug Robbins - Word MVP

unread,

Jul 16, 2003, 2:03:56 AM7/16/03

to

Hi Roger,

The simplest thing is to set up spreadsheet in Excel with a column of
numbers created by copying a formula that adds 1 to the cell above and then
use that spreadsheet as the data source for a label type mailmerge.

Please respond to the newsgroups for the benefit of others who may be
interested.

Hope this helps
Doug Robbins - Word MVP
"roger howland" <rogerh...@thedavidgroupinc.com> wrote in message
news:067401c34b4b$52a26270$a401...@phx.gbl...

Suzanne S. Barnhill

unread,

Jul 16, 2003, 8:32:29 AM7/16/03

to

FWIW, it's not necessary to use a formula in Excel. If you just enter the
first two numbers, you can use AutoFill to drag and fill as many more cells
as needed with sequential numbers.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word

"Doug Robbins - Word MVP" <d...@mvps.org> wrote in message
news:#Li6VB2S...@TK2MSFTNGP10.phx.gbl...

roger howland

unread,

Jul 17, 2003, 12:35:08 AM7/17/03

to

Thanks Doug, but I still need help...

The "number" is combined Alpha and Numeric, and neither
formating the cell as 'general' nor 'number' will work
[=A1+1] gets #VALUE!. This only works if the cell is all
numeric.

When I use all numeric I then get a column of
numbers....but to print labels, I have to enter one at a
time, or make them all the same number to print a sheet
of labels in word/tools "envelopes and labels"

Let me know what else to try or where to look

thanks

Roger

>.
>

roger howland

unread,

Jul 17, 2003, 12:38:43 AM7/17/03

to

Thanks Suzanne

but I still need help...

I couldn't find "AutoFill" in excel...I am trying to
populate sequential serial # tags on avery 5267 labels

The "number" is combined Alpha and Numeric, and neither
formating the cell as 'general' nor 'number' will work
[=A1+1] gets #VALUE!. This only works if the cell is all
numeric.

When I use all numeric I then get a column of
numbers....but to print labels, I have to enter one at a
time, or make them all the same number to print a sheet
of labels in word/tools "envelopes and labels"

Let me know what else to try or where to look

thanks

Roger

>.
>

Suzanne S. Barnhill

unread,

Jul 17, 2003, 10:46:56 AM7/17/03

to

If I enter GKFVB5261435 into a cell in an Excel sheet and GKFVB5261436 into
the cell below it, then select both cells and drag the AutoFill handle (it's
the square on the bottom right of the selection box), I get a series of
GKFVB5261437, GKFVB5261438, GKFVB5261439, and so forth for as long as I want
to drag. Excel doesn't care what the number format is.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word

"roger howland" <jobd...@cox.net> wrote in message
news:056c01c34c1d$4d7bd6f0$a501...@phx.gbl...

Graham Mayor

unread,

Jul 17, 2003, 12:41:27 PM7/17/03

to

See http://www.gmayor.dsl.pipex.com/Numbered_labels.htm

You don't need the text part of the number in the excel data only the
number. You can add the fixed text at the label.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gma...@mvps.org
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word