Create your own conference schedule! Click here for full instructions

Abstract Detail


Lowe, Phillip D. [1], Carter, J. Richard [1].

Two Birds with One Stone: Using Excel and Mail Merge to Create Herbarium Specimen Labels in Word and Populate a Specify Database.

We describe a method that uses Microsoft Excel to pivot between Microsoft Word and Specify 6. Field data are digitized from the field notebook into a formatted Excel document, then the Mail Merge feature of Word is used to format the digitized field data to produce customized herbarium specimen labels. Once the labels are generated, the specimens mounted, and their barcode labels attached, the barcode catalog numbers are scanned into the designated field in the Excel spreadsheet, providing the unique identifier required by the Specify database for each record. Subsequently, the data in the Excel spreadsheet are uploaded to the database through the Specify 6 Workbench. This system is flexible, efficient, and easy to use. It allows for customized formatting of herbarium specimen labels and eliminates keystroking of data into the database.

Log in to add this item to your schedule

Related Links:
iDigBio Small Herbarium Workshop Florida State University, 9-12 December 2013
Valdosta State University Herbarium [VSC]

1 - Valdosta State University, Biology, Valdosta, GA, 31698-0015, USA

Specify 6.

Presentation Type: Oral Paper
Session: 47, Systematic Methods, Herbarium Digitization & Floristics
Location: 203/Savannah International Trade and Convention Center
Date: Wednesday, August 3rd, 2016
Time: 4:15 PM
Number: 47011
Abstract ID:481
Candidate for Awards:None

Copyright © 2000-2016, Botanical Society of America. All rights reserved