View Single Post
 
Old 07-21-2014, 09:32 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Personally, I'd do this as a mailmerge, which doesn't require the use of any macros.

Attached is a revised version of your document and a dummy Excel data source for the merge. To use them, simply save both files to the same folder, then open the document and choose Mailings>Select Recipients>Use existing list, then navigate to and select the workbook. Once you've done that, click on Finish & Merge>Edit Individual Documents>OK. Word will then generate 24 pages of dividers, with 'Label 1' through 'Label 24', each offset on their respective pages.

This attachments are just a demo. You can change the label content and the number of labels by editing the workbook (close the Dividers document first) - but don't change the 'LabelData' heading. When updating the workbook, be careful to delete all empty rows below the final label. You can also edit the font size, alignment & and positions of the divider labels (bearing in mind that you need to leave a 1/4in paper-handling margin for most printers).

As you will see, the Dividers document consists of a 2*5 table. To see how the mailmerge determines which label to output in a given position, open the Dividers document and press Alt-F9 to reveal the field codes in the right-hand table column.
Attached Files
File Type: docx Dividers.docx (16.6 KB, 22 views)
File Type: xlsx LabelData.xlsx (8.2 KB, 47 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote