View Single Post
 
Old 03-28-2018, 11:58 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

You don't seem to be paying attention. All you need do is give the user a document with the correct table setup. This is a once-off exercise for which a macro is overkill. Indeed, having done it once, any such macro code would be redundant (since the table would already have the required formatting).

As for what you're trying to achieve, your penchant for using a macro will actually make things harder for anyone else to use and maintain the document & workbook in the longer term; a mailmerge is far simpler for anyone to use with minimal training.

Furthermore, regardless of whether the user types into the labels, employs a mailmerge, or runs a macro to populate the labels, the solution is the same once-off exercise: adjust the table margins.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote