Hello guys,



I have question, hard for me, im a new one there. Im not sure if its possible but im trying to make "print label" formular. Currently i have it done a simple one, where im copying cells in one table. The question is if i have more "sizes" for labels is it possible via macros to switching between them? Switching with choosing the right in some menu? That will appear as active so i can work with it.
Easy way is to make 2 word documents, but i know ur so good here.
I attached my "test" word. Can anyone help me?

Thank you

Attached Files

label.docm (59.5 KB, 12 views)

Switching labels requires far more than just a single change to the height and with of the cells in a table. If you use Word's label tools, you'll see that there is a myriad of label formats to choose from for a given page size. Not only can the number of labels across and down the page vary according to the label format chosen, but so too can the vertical and horizontal space between the labels.

If both of the label formats you require use the same data, I'd suggest populating an Excel workbook with those data and setting up two label mailmerges - one for each label type.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]