HLRosenberger
asked on
Help making labels in word
I know how to make labels in Word. But I want to make 132 labels, each with a different address. The address only differs by the house numbers. 11 buildings, buildings 100, 200, 300... to 1100, each with 12 units, so house numbers - 100-112, 200-212.... 1100-1112.
I do not care if I waste labels and get a whole sheet of labels, say starting at 100 to whatever, and then do 10 more sheets, starting at 200, 300, etc.
How can I easily do this?
I do not care if I waste labels and get a whole sheet of labels, say starting at 100 to whatever, and then do 10 more sheets, starting at 200, 300, etc.
How can I easily do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can quickly create the incremental data in excel and then use the mail merge in word to print the labels
http://office.microsoft.com/en-us/excel-help/print-labels-by-using-excel-data-in-a-word-mail-merge-HP005203760.aspx
If you use Avery (or compatible size labels) the avery software helps out as well.
http://office.microsoft.com/en-us/excel-help/print-labels-by-using-excel-data-in-a-word-mail-merge-HP005203760.aspx
If you use Avery (or compatible size labels) the avery software helps out as well.
ASKER
I used MailMerge and a CSV. Worked great!
Its Free also
http://www.avery.com/avery/en_us/Templates-%26-Software
FaithDan