If you don't find barcodesoft.bas, please download it from onecode.ĥ. Press Ctrl+M, it will popup a dialog, choose barcodesoft.bas under C:\Program File (x86)\CommonFiles\Barcodesoft\Fontutil folder. Usually it's under C:\Program File (x86)\CommonFiles\Barcodesoft\Fontutil folder.Ĭlick the checkbox beside crUFLBcs 1.0 Type Library as shown below. Click Browse button and choose cruflbcs.dll from your working folder. From Visual Basic editor, choose menu Tools => References. Press ALT + F11 to open Microsoft® Visual Basic editor.ģ. In the Macro Settings category, under Macro Settings, choose "Enable all macros" as shown below.Ģ. Then click Excel Options, choose Trust Center. If you are using Excel 2007 / 2010 / 2013 / 2016 / 2019, click the Microsoft Office Button. If you are using Excel 2000 or 2003, click menu => Tools => Macro => Security. Generate Intelligent Mail Barcode in MS Excel Spreadsheet Here are the nominal dimensions of BcsIM true type font characters Mailers get postal savings, mail tracking visibility and higher efficiency. When print at size 12, the printed intelligent mail barcode will meet USPS specification. Mailers can print the Intelligent Mail Barcode or OneCode from Microsoft Office®. It’s a smart and simple solution for mailers to use Barcodesoft Intelligent Mail barcode font. The Delivery Point ZIP Code may be 0, 5, 9, or 11 digits.
The total digits of Mailer Identifier and Serial Number are always 15.ĥ. The Mailer is a 6-digit or 9-digit number.Ĥ. You will assign a Sequence Number for tracking mail pieces. USPS will assign you a Barcode Identifier.Ģ. The Service Type Identifier is a 3-digit number assigned by USPS.ģ. USPS will assign you a Customer Identifier. The second digit is between zero and four. The Intelligent Mail barcode or OneCode has five data fields: Barcode Identifier, Service Type Identifier, Mailer Identifier, Serial Number, and Delivery Point ZIP Code.ġ. The Barcode Identifier is a 2-digit number.
The Intelligent Mail barcode or OneCode can encode up to 31-digits of mail-piece data into tracker, ascender, descender and full bar. Business mailers using Intelligent Mail barcode or OneCode is qualified to earn USPS automation discounts. The Intelligent Mail barcode or OneCode will replace the POSTNET and PLANET barcodes. The Intelligent Mail barcode or OneCode combines both ZIP Code and tracking information together and provides benefits to both mailers and postal offices. The Intelligent Mail barcode comprises 65 bars. The Intelligent Mail barcode is also known as USPS OneCode solution or USPS 4-State Customer Barcode (4CB, or USPS4CB). Keywords: USPS Intelligent Mail Barcode, USPS 4-State Custom Barcode, USPS OneCode Solutionīefore you print Intelligent Mail Barcode, please apply for an Intelligent Mail Mailer ID from USPS.