printing labels in word 2007



is there a way to desig and print number sequenced labels in Word without
having to type in the number for each label.
I want to use A4 sheet with 64 labels (Avery L7651) and print 7000
sequencial (1-7000) labels. Obviously this could be time consuming if i have
to type each label individually.... is there a quick method?

Many thanks



Doug Robbins - Word MVP on

In an Excel Spreadsheet, in the first column of the first row, enter the
word "Number", in the first column of the second row enter the numeral 1 and
in the first column of the third row, enter = A2 + 1 so that the numeral 2
appears in that cell. Copy that formula down 6,999 rows.

Then save that worksheet and use it as the data source for a label type
mailmerge in Word.

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

See the article "Mail Merge with Word 2007" on fellow MVP Graham Mayor's
website at

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question