![]() |
#1
|
|||
|
|||
![]()
I created a basic labels sheet and I'm looking to insert pictures (pictures of barcodes) into each label.
What options do I have to do this? I'm guessing it's something with mail mergers.. It must be automated, as I have approximately 13,000 barcodes I'd like to get into labels. ![]() **Edit** I am a Word noob but a veteran programmer and can whip up some VBA or VB programs to help if that's the best option. |
#2
|
||||
|
||||
![]()
Why are you not creating the barcodes (using a barcode font) in the Word document directly (e.g. via mailmerge)?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
I didn't know there was such a thing available in Word..
I can get to the point where I'm using mail merge to import our list of 13,000ish numbers into labels. How do I convert them into barcodes though? Sorry I'm not seeing any other information on my searches on how to do this.. |
#4
|
||||
|
||||
![]()
Assuming you're using a label merge and your data have already had whatever pre-processing might be required to get it into the barcode's syntax, it's as simple as applying that font to the mergefield. To do that:
• select the mergefield • press shift-F9 to expose the field code, which should look like: {MEREGFIELD Barcode} • add the CHARFORMAT switch to the field code, thus: {MEREGFIELD Barcode \* CHARFORMAT} • Format the M in 'MEREGFIELD' with your barcode and whatever point size you want it to be • Use the 'update labels' button to propagate the change to all labels • run your mailmerge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
Tags |
barcode, label |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
mqx | Word VBA | 4 | 11-13-2013 11:22 AM |
![]() |
PPTinJakarta | PowerPoint | 4 | 04-30-2013 01:56 AM |
![]() |
obasanla | Mail Merge | 6 | 11-26-2012 11:53 PM |
![]() |
nels04 | Word | 2 | 12-06-2011 03:48 AM |
![]() |
Mark | Drawing and Graphics | 3 | 05-06-2009 08:43 AM |