In my job I have to print label for very small vials. To make it scannable I think I need a 2D barcode. (1D will wrap around.) The original data is kept in excel.



What is the bast way to use mail merge to print the labels with unique 10 character barcodes? Get the 2D barcode into Excel first then mail merge the data and graphic barcode into the mail merge or should/can i enter collect all the data in Word and somehow get the barcode into the first mail merge document.



Also, is there a barcode typeface that works works in excel or word?



thank you,
Phil

Office 365