To clarify, this if for books in a library, so the process goes something like this:

-the books are cataloged in the ILS
-in the ILS I pull lists of the books to be labeled and then the call numbers are exported to a csv file in Excel. Ideally i do 100 at a time, as that is how many are on each sheet (8.5x11) but that is rarely the case, it varies...40, 50, 72, etc.
-in Excel, I manually shift the cells into columns of 10 each and then copy/paste that onto the dummy template Word file from the company that produces the labels. These are .75x1 inch labels, 100 per sheet.
-from there I highlight all the labels and use a macro I recorded which replaces all spaces with linebreaks (or maybe paragraphs is the correct term), changes the font to Arial rounded MT Bold, and sets the size to 11pt.
-THIS IS THE PART I AM LOOKING TO CUTDOWN ON: At this point I have to manually go through and modify any instances where the names or other info is too long to fit on a line, downsizing such lines to 10pt, 9pt, or whatever. Typically a string of 8 letters seems to fit, but more than that tends to throw off the formatting. So, if there were some way to automatically search for strings of 9 or more and downsize them to 10pt, I think that would be beneficial.


I have attached a couple of documents, the '.75x1' is the mostly blank template I paste the info into and the other is a recent sheet as it ended up being printed.

Attached Files

	.75x1.docx (12.4 KB, 7 views)
	2021_03_11_labels.docx (13.9 KB, 8 views)