Intelligent Mail Excel Add-In Download, Install & Use
Intelligent Mail is also called OneCode 4CB, USPS 4CB, 4-CB, 4-State Customer Barcode, USPS OneCode Solution Barcode, and USPS IM. It is a linear Postal Service barcode used to sort and track letters and flats.
Intelligent Mail (OneCode) Barcode Add-In for Excel is a robust and reliable barcode generator which allows users to insert and generate Intelligent Mail (OneCode) barcodes and other linear & 2D barcodes in Excel spreadsheets with just a few mouse clicks.
In barcodes generation, Intelligent Mail (OneCode) requires no programming skills and barcode fonts. And users can adjust various parameters of the created barcodes.
Intelligent Mail Add-In for Excel Features
|
Encodable Characters |
Numeric digits: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
|
MS Excel Version |
Compatible with Microsoft Office Excel 2007 and 2010 versions |
|
Multiple Usage |
- Support to create a single Intelligent mail barcode or a barcode list easily
- Simple to link barcode images to cells
|
|
Adjustable Image & Size |
Rich barcode settings are provided for users to customize their barcodes, like bar width, bar height, rotation, font, etc |
|
Human-Readable Text |
Users can choose to display the encoded characters in OneCode or not |
|
For All Printers |
The created barcodes can be printed by all printers! No special hardware or printers are required |
Intelligent Mail Add-In for Excel Requirements
Windows OS & .NET
Compatible with Microsoft Windows 7/XP/Vista, Windows Installer 3.1, VSTO 3.0 Runtime sp1, and .NET Framework 3.5 sp1. |
Microsoft Office
Compatible with Microsoft Office Excel Workbook 2007; Microsoft Office Excel Workbook 2010. |
Install Intelligent Mail Add-In for Excel
- Close all Excel documents to prepare installation;
- Download and unzip BizCode Add-In for Microsoft Excel;
- Run the setup file "setup.exe" to install this plugin;
- Open a new Excel document and click "Install" in a pop-up window;
- Now you can see a tab called "Add-Ins" in the Excel menu bar.
How to Create Intelligent Mail Barcode in Excel?
- Click "Add-Ins" tab in a new Excel document;
- A tab called "Barcode Settings" pops up on the right;
- Select "INTELLIGENT MAIL" in "Barcode Type" pull-down menu;
- Type valid data in the pane under "Data";
- Click "Generate" button and an Intelligent Mail barcode is created successfully;
- (Optional) Modify the parameters of the created barcode in "Barcode Settings";
- Click "Update" when you finish the revision.
How to Link a Barcode with a Cell in MS Excel?
- Generate an Intelligent Mail barcode and click "Link To Cell";
- Select a cell with valid Intelligent Mail data and click "Update";
- Now the barcode image is successfully linked to the data in the cell.
- Several barcodes which are linked to cells can be updated at one time;
- To achieve the function above, ensure all the barcode are linked to cells first;
- Modify the data in those cells and click "Update Link To Cell" button;
- Now all the barcodes are updated according to the revised data in the cells.
How to Generate a Barcode List in MS Excel?
- Open a new Excel document first and click "Add-Ins" tab;
- A barcode setting panel shows up on the right;
- Choose a list of cells and type valid data in them;
- Select all those cells and choose "INTELLIGENT MAIL" in "Barcode Type";
- Click "Generate" button and a list of barcodes appear on the document.
