Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 07-21-2014, 09:32 PM
macropod's Avatar
macropod macropod is offline Creating a macro for quick setup of tab\card dividers 5 tab Windows 7 32bit Creating a macro for quick setup of tab\card dividers 5 tab Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,523
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
 

Tags
dividers, macro, tabs



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a macro for quick setup of tab\card dividers 5 tab Need Help Creating Macro rsrasc Word VBA 4 03-28-2014 01:31 PM
Creating a macro for quick setup of tab\card dividers 5 tab 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft