Integrate barcode technology into Word documents
Avapose.Barcode for Excel
  • Mature barcode generation add-in for MS-Excel 2007/2010
  • Support 20+ common linear and 2D barcodes creation
  • Provide freely adjustable barcode options
Barcode Excel > Barcode in Excel > Linear > Intelligent Mail
Intelligent Mail Barcode Generation on Excel
  • Mature and professional component for Intelligent Mail creation on Excel
  • Compatible with commonly used OS like Windows 7, Windows XP, etc
  • Create Intelligent Mail straightforward on Excel spreadsheet with simple clicks
  • Output Intelligent Mail on all printers without any hardware extensions
  • Intelligent Mail text can be hided for other applications if required
  • All barcodes are pre-configured conforming to industry standards
  • Royalty-free with the purchase of Excel Intelligent Mail Add-In developer license
  • Dynamic OneCode can automatically update with the data of the linked cell
Using Intelligent Mail Barcode Add-In for Excel, users can let high quality Intelligent Mail generation on Excel be quickly finished. And a list of OneCode barcodes can be produced easily with simple clicks. In addition, more advanced bar-coding tasks, like dynamically linking barcodes with the content of your spreadsheet, are supported as well.
Intelligent Mail Add-In for Excel - Intelligent Mail Information
Intelligent Mail, also called OneCode, is a height-modulated linear barcode type, which can only encode numeric digits (0 through 9). It effectively incorporates the routing ZIP code and tracking information included in previously used postal barcode standards and is widely used by the United States Postal Service for domestic mail delivery.
Intelligent Mail Valid Encoding Characters:
  • Numeric characters: 0 - 9
Intelligent Mail is a fixed length barcode with 20, 25, 29 or 31 numeric digits.
Intelligent Mail Add-In for Excel - Intelligent Mail Generation

Requirements:

Install all below for OneCode creation on Excel:
  • Microsoft Office 2007 PIA
  • .NET Framework 3.5 SP1
  • Windows Installer 3.1
  • VSTO 3.0 Runtime SP1
  • Avapose.Barcode for Excel

Generate a Single Intelligent Mail on Excel

  1. Start the target Excel spreadsheet and activate Excel Barcode Add-In by clicking "Create Barcode" under "Add-Ins" tab;
  2. Select a certain cell and choose "INTELLIGENT MAIL(ONECODE)" in the "barcode type" pull-down list;
  3. Enter data that is required in the "data" box, like "98765432109876543210" (20, 25, 29 or 31 numeric digits are allowed to be encoded);
  4. Adjust the parameters that are required like "Bar width", "Bar height", "Display check char", "Rotate", etc;
  5. Click "Generate" to output the target Intelligent Mail on the chosen cell of Excel.
If there is some requirement to customize the generated Intelligent Mail, please select it and adjust the related properties in the setting panel. After that, click "Update". Alternatively, you can delete the barcode by clicking "Delete" button and generate a new one.

Create Intelligent Mail Lists on Excel

  1. Open the Excel Barcode Add-In;
  2. Select a list of cells, choose "INTELLIGENT MAIL(ONECODE)" in the "barcode type" pull-down list and input the data to be encoded;
  3. Customize the parameters that you need like "Bar alignment", "Bar height", "Display check char", "Rotate", etc;
  4. Click "Generate" and a list of Intelligent Mail barcodes appear on Excel as required.

Link a Intelligent Mail to a Certain Cell on Excel

The barcode can update automatically with the content of the linked cell after you do as follows:
  1. Select the generated Intelligent Mail and click "link to cell";
  2. Select the target cell with data;
  3. Click "Update" where "link to cell" button is located;
  4. The generated Intelligent Mail is dynamically linked to the target cell.
Testimonial for Avapose.Barcode for Word
We bought your product Barcode Add-In for WOrd a few weeks ago, and it works pretty well!
Carios Louis, Eureka Software Ltd, UK