| || |
By Lance Zakin, HCL CASA, CAAD
Notes and Domino
HCL BP NotesMail
|Barcodes can be displayed and printed in Notes quite easily using the Print Merge Reporter tool. For example, you can display several different types of barcodes in your custom Notes Views and Forms. Barcodes can be printed to hard copy printer, and saved in formats: Excel, Word, PDF, XPS, etc.|
Barcode data can be automatically mail merged from your custom Notes DB to labels, envelopes, letters and directory in Word. And if your barcode data exists in Excel, then it can be imported into the tool or your custom Notes DB, then automatically mail merged to labels, envelopes, letters and directory in Word.
Print Merge Reporter is basically a Notes DB which supports barcoding and automated mail merging. The Notes barcodes include USPS Intelligent Mail (IMb), Code 39 (Code 3 of 9) and Codabar, as well as, support for other Notes barcodes upon request. The Notes barcodes are compatible with Notes running on Windows. You must log off or restart Windows after installing barcode support using the "Mail merge printer request" configuration profile as seen in a screenshot below.
Mail Merge barcodes to Word as Labels, Letters, Envelopes, Directory using Print Merge Reporter
Print Merge Reporter has an easy configuration screen which will automatically generates barcodes using data from any custom Notes DB or Excel spreadsheet. The barcodes can be generated by either (1) Clicking the generate mail merge button in the Print Merge Reporter DB, or (2) Clicking a customized button in a custom Notes DB containing the barcode data. NOTE: Formula code for the customized button can be copy/pasted from the online help which provides seamless integration functionality for a custom Notes DB.
Displaying barcodes in Notes Views and Forms
For example, if you select a Code 39 barcode, you must include the asterisk character "*" or the exclamation "!" as the start and stop of each barcode for it to scan properly. The steps below creates a barcode that encodes the number in Notes field with the Code 39 barcode. NOTE: Barcode names containing "HR" are human readable. Barcode names starting with "sIDA" are demo barcodes in the evaluation software, where as, barcode names starting with "IDA" are fully functional in the licensed software.
NOTE: You may also use the parentheses () instead of “!” or “*” as the start and stop code to eliminate the “*” from appearing in the human readable version of the barcodes. When you are using the Codabar barcode, you should use the upper case letter "A" or "B" as the start and stop of each barcode.
- Edit a Notes View column or Notes Form field, then select a barcode name from the font list. i.e. sIDA Code 39 HR Short (demo), IDA Code 39 HR Short
- Edit a Notes field or Notes view column formula, then type the start character, in this case it is "*"
- Append a field name or formula computed to a text data type. i.e. @Text(numBarcode)
- Append the stop character, in this case it is "*". See screenshot example below.
Notes View screenshots:
Notes Form screenshots: