Menu Flyout

Label Production & Tools

  • Barcode font
  • Microsoft Office word 2007
  • Microsoft Office Access 2007
  • Avery White File Folder Labels 5366
  • Printer
  • Previously poured agar plates
  • Label Template
  • Large storage containers

Get a complete listing of tools

4) Label Production

4.1)  If one would like to have the barcode font as a part of the labels, proceed with step 2.2, if not, skip to step 2.4.
4.2) Download a barcode font such as Code 128 from an appropriate source such as http://freebarcodefonts.dobsonsw.com/code128-word-addin.html.
4.3) Follow the company instructions for installation of the program into Microsoft Word. 
4.4) Open up Microsoft Word (These directions refer to Microsoft Word 2007).
4.5) Under the Mailings tab click on the Start Mail Merge button under the Start Mail Merge submenu then choose Labels.
4.6) Choose the appropriate label vendor and product number indicated on label package. Click OK. 
4.7) Click on Select Recipients from the Start Mail Merge submenu. 
4.8) Choose Use Existing List and locate the database containing the metadata associated with one's experiment. Note: Database information and fields are based upon the user's discretion appropriate for the experiment.
4.9) From that database, choose the sheet containing the specific information that should be incorporated on the labels. e.g. Plate Properties. 
4.10)   Insert fields from the chosen sheet in order to lay out the desired label format. 
4.11) To insert a field, click on Insert Merge Field from the Write & Insert Fields submenu. Choose the desired field/fields in dropdown box. To preview results choose the Preview Results button in the Preview Results submenu. Alignment, font, size etc. can easily be adjusted in this view. e.g. barcode font 
4.12) After the first label is formatted as desired, click on Update Labels under the Write & Insert Fields submenu. 
4.13) To preview the labels, click the desired record number in the Go To Record input box under the Preview Results submenu. Note: the record number is not the same as the unique ID number in the Access Database. The record number is in the lower left hand corner of the Access sheet. 
4.14) To print the labels, click on Finish & Merge in the Finish submenu. Choose Print Documents and type appropriate record number range in the dialogue boxes. Click OK.
4.15) Set the desired printer settings. Click OK.
4.16) Place labels on previously made agar plates using designated template.
4.17) Organize labeled agar plates in storage containers to prevent drying out and for planting convenience.