Print labels with a consecutive number

[TomC]

I'm using Win XP Home Edition and have the Office Professional software. I
need to print some Avery Labels with a consecutive number. Could you point
me in right direction to do this? I have experience with the Word Mail Merge
and with Access. Just don't know how to create a data file with just a
consecutive number in it.
Thanks for any help.
Tom

 

[Herb Tyson [MVP]]

In Word, you can do this by creating a file that contains a series of SEQ
fields. With field codes expanded, it would look like this:

{ SEQ XXX }
{ SEQ XXX }
{ SEQ XXX }
{ SEQ XXX }

 

[Herb Tyson [MVP]]

Accidentally brushed the touch pad before I was done...


You will probably want to add a number switch so that the numbers are all
formatted consistently. For example:

{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}
{ SEQ XXX /# 0000#}

would yield:

00001

00002

00003

00004

00005

00006

00007

00008

00009

00010



So, insert one field, then copy/paste to replicate. Select all of the fields
and press F9 to update them and turn them into a sequence. I gather that
once you have this, you'll be able to get it into Access, a mailmerge for
labels, etc., as needed.