Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
printing labels in word 2007
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_lab...th_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 "slimady" wrote in message ... 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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
printing labels in word 2007
See also http://www.gmayor.com/Numbered_labels.htm and in particular the
add-in available there. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org slimady wrote: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Avery Labels in MS Word 2007 | Microsoft Word Help | |||
Word 2007 - Printing Labels - Only shows Page 1 of 1 | Mailmerge | |||
printing multiple labels in Word 2007 | Microsoft Word Help | |||
Printing labels in 2007 | Microsoft Word Help | |||
Printing labels in Word 2007 | Microsoft Word Help |