![]() |
|
#6
|
||||
|
||||
|
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Tags |
| dividers, macro, tabs |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Need Help Creating Macro
|
rsrasc | Word VBA | 4 | 03-28-2014 01:31 PM |
Creating a generic macro?
|
suerose | Word | 2 | 07-04-2011 07:59 PM |
| add macro to quick access toolbar | TessaLee | Word VBA | 2 | 03-16-2011 06:31 PM |
| Creating a MACRO | Nikb3522 | Word VBA | 0 | 10-21-2010 05:55 PM |
| creating macro | steveb | Word VBA | 0 | 08-14-2010 01:29 AM |