printing labels in word 2007

[slimady]

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 news.microsoft.com]

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

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

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

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


--
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 msnews.microsoft.com

 

[Graham Mayor]

See also http://www.gmayor.com/Numbered_labels.htm and in particular the
add-in available there.

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


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