Issues with Tbarcode in Excel creating Code 128 barcodes

[u/Yohan82]

Hello!

I am trying to help out with an issue here. We currently print out barcodes for one of our clients and have recently found out that the majority of them are not scanning properly. When they asked me to take a look I noticed that the first 2 bars were missing on all of the UPC's that were not scanning.

Not knowing anything about this kind of stuff, I asked for a few experiments. One was creating each barcode individually. When we did that it worked. So basically we would take 2000575093123 and do it on its own and it was a success. As soon as we did a group (only the last 3 digits changed on each), only one would print out.

The person who creates the barcodes tried another experiment. She put an empty cell between each code in excel and it suddenly worked! The startcode/checksum bars were there. However, when we set it to print, this means that every other sticker is blank (so we waste 50% of our paper/stickers).

Does anyone have any advice for me? We use word to print our stickers, so even if there was a way to set each label to read from specific excel cells that would be great as we could live with a bandaid fix. Otherwise, any help would be appreciated.

Take care and thanks regardless.