New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions

Code 39 Printed on Pre-made Label Stock

We are using Code 39. We only have to do five total labels (although we need to print hundreds of each).

We do not want to go through the trouble of an Excel-to-Word mail merge.

In this case, how do you suggest we print on pre-made label stock (like Avery)?

Operating System: Windows

Application: Excel, Word

09-22-14     9.4 year(s) ago    

  Report Abuse

 

James

Best Answer

Since the actual variation of Code 39 barcodes is a small number, the mail merge process can be avoided.

The following is what is recommended:
1. Use the IDAutomation Barcode Label Software:

Note: Choose Next/Ok between each step.

image

image

• Choose Label Product (8162 in this example):

image

• A 'single label' will be seen, choose highlighted ('Add Linear Barcode' button):

image

• Right-click the barcode that appears, and choose these options (assumes no check digit is wanted):

image

image

image

• Align barcode by 'drawing a box around barcode’ (with the mouse, bottom right to top left in this example):

image

• Right-click the barcode and align it horizontally and vertically:

image

• Print by going to File > Print Preview, choose Currently Selected, set Duplicates to 14 (determined by label type), and choose Print Preview. A preview of the page will show the labels.

• Print by choosing File > Print.

• Calculate how many sheets are needed for the batch. For example, if 500 labels of the same barcode are needed, divide 500 by the total amount of labels per sheet, which will give you the total sheets to print (rounding up).

2. Use the IDAutomation Code 39 Barcode Font Package and Microsoft Word to manually enter the data:

Note:
• The following is possible because Code 39 uses start and stop characters (*, !, and parentheses) and does not require a separate encoder.
• Choose Next/Ok between each step.


• Open a new document in Word (should be a similar process for all versions).
• On the Mailings tab, choose Labels, and the ‘Envelopes and Labels’ dialog will appear.
• Enter the data surrounded by * (a Code 39 start and stop character) in the Address field. Choose 'Full page of the same label' under Print. Since Avery 8162 is being used, choose it under Label:

image

• When done, choose the New Document button, which produces an entire sheet of the same text on each label.

• It is now possible to arrange the text to the desired positions using Word's many options.

• When the positioning of the text is complete, choose one or all the label data and assign the desired Code 39 Font. In this example, a font with human-readable text below the barcode is chosen:

image

• The barcodes are now seen on the labels. The label on the left, *ABC123*, uses * as a start and stop character, which can be seen in the human-readable text below the barcode. The label on the right, (ABC123), uses parentheses instead of * for the start-stop characters (to not show the human-readable text below the barcode):

image

• Print by choosing File > Print.

• Calculate how many sheets are needed for the batch. For example, if 500 labels of the same barcode are needed, divide 500 by the total amount of labels per sheet, which will give you the total sheets to print (rounding up).

Posted 9.4 year(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.

Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2021 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook