Printing EPDM BOM to label printer

We are a small business and currently export EPDM BOMs to Excel and then print them out to create a picking list.

What I would like to do is print a BOM as labels with one label per line item. (Each label would show part number, revision, description, qty etc.). We can then use the roll of labels to kit from. There could be ~1000 labels from a top level BOM.

Something like a Zebra, Brother or Dymo printer look fine, but does anyone have recommendations/experience of using their printing software in terms of taking the BOM and automatically generating all the labels?

thanks,

Richard

SolidworksSolidworks Pdm enterprise Pdm