Printing Barcode Labels

Top  Previous Topic  Next Topic

Barcode printing is only available with the Level 5 (or higher) program.

To reach the Barcode Printing dialog box, start in the Product Information Database and select FILE >> PRINT BARCODE LABELS.

The dialog box that appears look very much like the Print Mailing Labels and Print Shipping Labelsdialog boxes.  Both are good references if you need details on any aspect of the "Print Barcode Labels" dialog box.

The "Print Barcode Labels" dialog box allows you to select from one or more label formats that you might use in printing labels.

To use the "Print Barcode Labels" dialog box, select which label format you want from the upper left of the dialog box.  Then click on "Create List and Continue Process."  When you click on this button, AnyOrder will automatically open up your word processing program with the labels in place and ready to go.  You can make one final review in your word processor, and print the labels when you are ready.

The printing of labels is guided by something called label properties.  You can review label properties by clicking on the "View or Modify" button.  If desired, you can also create your own label formats by clicking on "Create a New Format."

The properties are very similar to Mailing Label properties.  There are, however, two differences:

1. Do not format barcode numbers for Code 39.  The Code 39 barcode font requires that an asterisk (*) be placed at the start and end of the barcode.  However, you not limited to using the code 39 font.  If desired, you can purchase and use other barcode fonts.  If you do use another font, you'll want remove the checkmark, eliminating the asterisks.

2. Number of records to create. The actual number of records that you'll need are determined by how many labels fit on one page of the label paper that you use.  By default, AnyOrder will create 100 labels of the same barcode, more than enough to fill out one page.  In most cases, you won't have to change the number.  But, if desired you can control the number of records you want sent to your word processing program by entering the number here.

For information on the rest of the "Properties" dialog box, see mailing list properties.

Sample Labels

The sample barcode label that comes with the program is designed to be used in combination with Microsoft Word.  If you have Microsoft Word on your computer, it's worthwhile to run through the process described below.

The sample assumes that you've installed AnyOrder to the default directory:  C:\AnyOrder.  If you've install it to a different directory, you'll need to do two things.  First, check to see if AnyOrder has the correct directory paths in the "Label Properties" dialog box (reached by clicking on "View or Modify" on the upper right of the screen.)  See Mailing Label Properties for more information.  And, secondly, you'll need to start Microsoft Word and load in the following document: BarCode_Labels.doc. BarCode_Labels.doc is found in AnyOrder's "Labels\" sub-directory.  You'll need to use the Mail Merge Wizard and change the path of the data source (BarCodes.txt) to the "Labels" sub-directory under the name of the installation directory you've used (see Mailing Label Properties).  Once again, this is only necessary if you've installed the program some place other than C:\AnyOrder.

Start at the Product Information Database.  Make sure you have entered a number in the Barcode Field.  Then select FILE >> PRINT BARCODE LABELS.

The "Print Barcode Labels" dialog box will appear.  Make sure "Sample: Barcode Labels" is selected, and click on "Create List and Continue Process."  A dialog box will appear asking you for the path to Microsoft Word.  Once you've enter the path, AnyOrder will remember it for future sessions.

(Note: newer versions of Microsoft Word will trigger the following message:  "Opening this document will run the following SQL command …"  Just click on "Yes."  You can remove this message by following these directions: MS Word Hints.)

Microsoft Word will start up.  The label document (BarCode_Labels.doc) will be automatically loaded.  On the Microsoft Word screen, you should see the barcode, name of the product and price.  If, instead of the barcode, you see <<BARCODE>>, you'll need to click on the "View Merged Data" button to change the view so you can see the actual data.  (Microsoft is always changing things and changing terminology.  Information on the "View Merged Data" button (or whatever Microsoft calls it in the latest version) and other mail merge features are found in Word's help documentation.)

Important Note:  Microsoft Word's merge functions are notoriously finicky and you may not see your current data when the program first opens.  In fact, you may see the data from your last export.  Because of this, it's always a good idea to do a quick check.  In newer Word programs make sure the "Mailings" ribbon is showing. In older Word programs: select Tools >> Letters and Mailings >> Show Mail Merge Tool Bar.  Then for newer Word program, click the "Preview Results" button off and on.  Or for older Word program, click the "View Merge Data" icon off and on.  That refreshes the screen so that you'll see your new data.

If you do not see the barcode -- in other words, if you see numbers on the screen rather than the barcode -- it means that you need to manually copy the barcode font to the Windows font directory.  For more information, see Barcoding Features.

This sample uses a common label lay-out.  This particular format is Avery 5160, but other companies sell equivalent label paper.  You can purchase Avery (or other manufacturer's) label sheets at most office supply stores -- or on the Internet.

At this point, you can run a print on ordinary paper to see how it looks.  To print it, select FILE >> PRINT.

If desired, you can use the sample as a starting point to design your own labels.  Use MS Word's Mail Merge Wizard to select the type of label paper you want and format the address to your liking.  (Depending upon the version of Word, the wizard is commonly found at:  TOOLS >> LETTERS & MAILINGS >> MAIL MERGE WIZARD)

Other Barcode Fonts

It is possible to use other barcode fonts instead of the Code 39 font that comes with AnyOrder.  It is just a matter of installing the font, and reformatting the barcode numbers in Microsoft Word with the new font.  Be aware, however, that some barcode fonts (such as Bookland EAN and UPC variations) require check digits.  AnyOrder is not set-up to handle check digits.  In those cases, you'll want to purchase specialized barcode printing software.

More Information

For more information on barcodes, see Barcode Features