Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2021, 06:08 PM
Philler Philler is offline inserting a 2D barcode into small mailmerge label Windows 10 inserting a 2D barcode into small mailmerge label Office 2019
Novice
inserting a 2D barcode into small mailmerge label
 
Join Date: May 2021
Posts: 2
Philler is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-31-2021, 07:04 PM
macropod's Avatar
macropod macropod is offline inserting a 2D barcode into small mailmerge label Windows 10 inserting a 2D barcode into small mailmerge label Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could use Word's MERGEBARCODE field...

See: Field codes: MergeBarcode - Word
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-31-2021, 08:15 PM
gmayor's Avatar
gmayor gmayor is offline inserting a 2D barcode into small mailmerge label Windows 10 inserting a 2D barcode into small mailmerge label Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #4  
Old 06-06-2021, 04:28 AM
Philler Philler is offline inserting a 2D barcode into small mailmerge label Windows 10 inserting a 2D barcode into small mailmerge label Office 2019
Novice
inserting a 2D barcode into small mailmerge label
 
Join Date: May 2021
Posts: 2
Philler is on a distinguished road
Default 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,
Reply With Quote
  #5  
Old 06-06-2021, 04:58 AM
macropod's Avatar
macropod macropod is offline inserting a 2D barcode into small mailmerge label Windows 10 inserting a 2D barcode into small mailmerge label Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Philler View Post
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.
Barcodes such as Code 128, 2D, etc., have no one-to-one relationship between the characters the barcode represents and the characters themselves, due to the compression algorithms etc. used to generate the barcode. In any event, if there were such barcode fonts (as there are for 3 of 9, for example), you wouldn't need to get them from MS.

In any event, why aren't you using Word's MERGEBARCODE field?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting a 2D barcode into small mailmerge label Mail Merge is appending blank label to every legit label Involute Mail Merge 2 12-11-2020 08:52 PM
inserting a 2D barcode into small mailmerge label 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
inserting a 2D barcode into small mailmerge label 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft