labels

[Guest]

I am making labels for boxes. They are numbered. the first on will be 8450,
then 8451 and so on. Is there a formula or something that I can use without
having to type each one in seperatly?

 

[Jay Freedman]

I am making labels for boxes. They are numbered. the first on will be
8450, then 8451 and so on. Is there a formula or something that I can
use without having to type each one in seperatly?

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

 

[Suzanne S. Barnhill]

You can use SEQ fields.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

I have another question. I used the Macro. The first label started at 8450,
but then the next one was it 16900, then 25350, 33800, 42250, 50700. Is there
something I did wrong maybe? Thanks. Nora

 

[Jay Freedman]

Is there something I did wrong maybe?

Probably. The line in the macro

startNum = startNum + 1

is meant to increase the number by 1 each time another label is filled in.
Instead, your numbers are increasing by 8450. Did you type that line
incorrectly?

If you can't spot the error in your copy of the macro, copy the whole macro
from your Visual Basic editor and paste it into a reply here so I can have a
look.

 

[Guest]

Thank you so much Jay! It works. It works. I can't believe I actually did it.
Now I don't have to type them all in. Thanks for your help.
Nora

 

[Graham Mayor]

Hmmmm. The problem with SEQ fields is that they don't work correctly with
label mail merges. They start renumbering at each new page.

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

My web site www.gmayor.com

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

 

[Suzanne S. Barnhill]

There was no mention of mail merge in the original post.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Graham Mayor]

True enough, but it's a point to note if making lots of labels, where mail
merge would be the obvious ploy.

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

My web site www.gmayor.com

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