|
#1
|
|||
|
|||
USPS Intelligent Mail Encoder How to Remove Text from Column?
(I edited my original post because I gave a link to the excel file from the USPS...that was an error, it's an integration .exe and I understand you folks not wanting to do an install...so, try again) I'm using the USPS Intelligent Mail Barode Excel file to print envelopes. It is annoying that the spreadsheet automatically puts "input track string must have 20 digits" in EVERY blank row! I want a blank row to print blank..as it is now, I must delete the "input track string must have 20 digits" text in every row that should be blank...time waster and annoying! Cannot figure out how to get rid of the text? Everything I've tried results in the sheet blowing up on me. The attached pic shows the contents of J2 that produce the text string "input track string must have 20 digits"and for K2, it says K2 = J2...so I just need to know what J2 is all about and how I get rid of that text string and just have a blank cell. Good luck! I surrendered Last edited by 16NOV2020; 11-17-2020 at 08:11 AM. |
#2
|
|||
|
|||
I wanted to add that I open/print the excel database file using Word and it's Office 365.
|
#3
|
|||
|
|||
can you upload the sheet with data in it? i dint really want to install the software if not needed
|
#4
|
|||
|
|||
Sorry.
Edited for me being a dunce... Last edited by 16NOV2020; 11-17-2020 at 08:12 AM. |
#5
|
|||
|
|||
Both of those downloads have a "Setup.exe" file. Neither has an Excel file.
|
#6
|
|||
|
|||
Yes that is what i got
|
#7
|
|||
|
|||
sorry folks...I messed up from the beginning...it's an integration exe file, not an excel file...been so long since I set this up, forgot how it worked.
Please see original post, edited it and uploaded a picture. Uploading the XLS file won't work because you need to install the exe to use it which I understand you folks not wanting to do... |
#8
|
|||
|
|||
Okay, still struggling with outplaying with it, can you upload anyone. I might be able to install on my test machine
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Intelligent Mail Bar Codes | gw1500se | Excel | 0 | 05-26-2017 06:52 AM |
Macro to keep first instance and remove duplicates in certain column | zhead | Excel | 2 | 03-18-2015 10:16 AM |
Macro to remove blank column | netchie | Word VBA | 4 | 03-14-2013 02:22 PM |
Intelligent document -> outlook conversion? | spoonerm | Word | 3 | 10-04-2011 08:20 AM |
How to do intelligent autonumbering? | nwong1288 | Word | 0 | 02-26-2010 01:25 PM |