Generating PostNet Mailing Codes in Excel with ConnectCode
Installing and Using the ConnectCode Barcode Fonts Encoder in Microsoft Excel
ConnectCode Barcode Encoder is a free app for Office that enables you to create barcodes using fonts in Microsoft Excel 2013/2016. The app encodes data from the cells of an Excel spreadsheet into output characters to generate high quality barcodes which meet all industry compliant requirements.
- Excel 2013 or Later
- on Windows
- on macOS/OSX (without fonts installer)
Does Not Work With
- Excel Web App
- Excel Mobile App
Preparing to Create Barcodes
- In Excel, open the spreadsheet containing the address records or at least Zip codes (or Zip+4 9-digit Zip codes). If you don’t already have such a document prepared, create a new blank spreadsheet just to facilitate installing of the needed Excel add-in.
- Select an empty field and go to the Insert tab in the Ribbon. Click on the Store button to open the Apps for Office online store.
- In the Search field in the top-left, search for “connectcode”. Case is irrelevant.When you see the ConnectCode Barcode Fonts Encoder add-in appear, click the Add button to download and install the add-in.
- If prompted with this confirmation, click the Trust This App button. Excel will then finish installing the ConnectCode Barcode Fonts Encoder add-in.
With the correct add-in installed, you’re now ready to generate POSTNET mailing barcodes within Excel.
Generating POSTNET Barcodes in Excel
- In your Excel spreadsheet, select an empty cell and go to the Insert tab in the Ribbon. Click on the My Apps dropdown button and choose ConnectCode Barcode Fonts Encoder. That will load the ConnectCode add-in into the Add-In sidebar.
- Select some or all of the cells containing the Zip codes (or Zip+4 9-digit Zip codes).
- In the Barcode Encoder sidebar, choose POSTNET from the Barcode list, and then click the Select and Encode button. It will seem like nothing has happened, but in the background, ConnectCode has processed your Zip codes.
- Select the empty cells into which you want to place your POSTNET mail bar codes–the same number of cells as the Zip codes you selected and encoded. Now click the Generate Output button in the Barcode Encoder sidebar.The result will be brace-wrapped POSTNET code numbers.
- With the brace-wrapped POSTNET code number cell still selected, go to the Ribbon’s Home tab and, from the Font menu, choose the CCode39_53 font to convert the numbers to an actual bar code. Set the Font Size field to 24. If you don’t have CCode39_53 or other barcode fonts, see below.
If the barcode fonts weren’t correctly installed with the ConnectCode Barcode Fonts Encoder add-in from the Office App store, you can download the font installer directly from the manufacturer at https://www.barcoderesource.com/buy.html.
There is also a free trial version available from https://www.barcoderesource.com/download.html.