Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2014, 08:09 AM
Ravon Ravon is offline Insert different images to multiple labels Windows 7 64bit Insert different images to multiple labels Office 2007
Novice
Insert different images to multiple labels
 
Join Date: Oct 2014
Posts: 2
Ravon is on a distinguished road
Default Insert different images to multiple labels

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.
Reply With Quote
  #2  
Old 10-15-2014, 01:37 PM
macropod's Avatar
macropod macropod is offline Insert different images to multiple labels Windows 7 64bit Insert different images to multiple labels Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

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]
Reply With Quote
  #3  
Old 10-16-2014, 08:43 AM
Ravon Ravon is offline Insert different images to multiple labels Windows 7 64bit Insert different images to multiple labels Office 2007
Novice
Insert different images to multiple labels
 
Join Date: Oct 2014
Posts: 2
Ravon is on a distinguished road
Default

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..
Reply With Quote
  #4  
Old 10-16-2014, 01:13 PM
macropod's Avatar
macropod macropod is offline Insert different images to multiple labels Windows 7 64bit Insert different images to multiple labels Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

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]
Reply With Quote
Reply

Tags
barcode, label



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert different images to multiple labels Insert images with incrementallly-numbered filenames mqx Word VBA 4 11-13-2013 11:22 AM
Insert different images to multiple labels Using Triggers to fade out multiple images PPTinJakarta PowerPoint 4 04-30-2013 01:56 AM
Insert different images to multiple labels Insert picture background in Word mail merge labels obasanla Mail Merge 6 11-26-2012 11:53 PM
Insert different images to multiple labels Editing multiple labels nels04 Word 2 12-06-2011 03:48 AM
Insert different images to multiple labels Multiple Background Images in MS Word 07 Mark Drawing and Graphics 3 05-06-2009 08:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:58 PM.


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