Labels printing algorithms for best fit on a page

[jimrward]

Currently I print a number of labels for a customer from 1 to N labels on a dymo label printer as a continuous feed
1 generate the csv file in excel/vba
2 open up Dymo app load data and print
2.1 I can use vba to print directly using the Dymo sdk for a small amount of labels

What I would like to do is move across to sheets of labels to speed the process up and print from a laser printer with sheets of labels stock
I don’t want to do a page per customer I would rather make the break between customers on a row basis to maximise my stock

So if my label sheet is 3 across and I have 7 labels to print I don’t mind wasting 2 labels and beginning on row 3 for the next customer

I appreciate that this may have to be driven from MSWord side not a problem as my vba is quite reasonable across products
Has anyone got some code that I can feed it labels across, as number on sheet is irrelevant to break on row boundaries per customer to give me best fit
One option is to calculate the number of labels required and add the padding with dummies to the csv file to be a multiple of labels across