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]
|