Print to labels ...

[adambc]

I have a Workbook that creates a series of same size arrays that I want to print to an A4 sheet of labels (L7202, 192mm * 38mm, 7 to a page) ...

Other than playing with the column widths and row heights, is there any way I can specify the print size of each array ie each array will print 192mm * 38mm (I know I will have to play around with spacing)?

FYI ... the arrays do not lend themselves to a "mail merge" ...

Thanks ...

 

[mackc557]

Depending on what you are working with you could export the Excel data to Access and use the print with label formatting option. You can select the brand and specific size of label and it will know where to print from there. You can even customize how it looks on the label.

 

[adambc]

Depending on what you are working with you could export the Excel data to Access and use the print with label formatting option. You can select the brand and specific size of label and it will know where to print from there. You can even customize how it looks on the label.

Unfortunately I don't have Access (macOS) ...