#1
|
|||
|
|||
inserting a 2D barcode into small mailmerge label
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 |
#2
|
||||
|
||||
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
See Bar Coded Labels
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#4
|
|||
|
|||
Barcode in Excel for Mailmerge
I read your page "https://www.gmayor.com/bar_coded_labels.htm " and had a question.
>>> However the field containing the data to be converted to a bar code, must be pre-entered with the Barcode start and end characters.<<< What is meant here? You don't show any characters in the code column. Also, is it difficult for MS to actually have a barcode typeface as they would Helvetica? Type in the characters, highlight, and the typeface changes. As an MVP I presume you would have better knowledge. I'm sure there is some technical reason. Thank you, |
#5
|
||||
|
||||
Quote:
In any event, why aren't you using Word's MERGEBARCODE field?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge is appending blank label to every legit label | Involute | Mail Merge | 2 | 12-11-2020 08:52 PM |
Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? | Jake93 | Mail Merge | 3 | 07-02-2019 05:38 PM |
How to start a label mail merge at a specific label? | DHKaplan | Mail Merge | 2 | 04-17-2014 07:33 PM |
Userform label bordercolor not controllable if click label | skarden | Word VBA | 1 | 09-29-2013 07:27 PM |
MICROSOFT barcode control -changing the barcode image in realtime | artner0112 | Excel | 1 | 12-18-2011 09:33 AM |