Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2020, 08:30 AM
16NOV2020 16NOV2020 is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2019
Novice
USPS Intelligent Mail Encoder How to Remove Text from Column?
 
Join Date: Nov 2020
Posts: 4
16NOV2020 is on a distinguished road
Default 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


Attached Images
File Type: jpg TrackingString.JPG (41.1 KB, 13 views)

Last edited by 16NOV2020; 11-17-2020 at 08:11 AM.
Reply With Quote
  #2  
Old 11-16-2020, 09:29 AM
16NOV2020 16NOV2020 is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2019
Novice
USPS Intelligent Mail Encoder How to Remove Text from Column?
 
Join Date: Nov 2020
Posts: 4
16NOV2020 is on a distinguished road
Default

I wanted to add that I open/print the excel database file using Word and it's Office 365.
Reply With Quote
  #3  
Old 11-16-2020, 02:51 PM
Purfleet Purfleet is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

can you upload the sheet with data in it? i dint really want to install the software if not needed
Reply With Quote
  #4  
Old 11-16-2020, 04:22 PM
16NOV2020 16NOV2020 is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2019
Novice
USPS Intelligent Mail Encoder How to Remove Text from Column?
 
Join Date: Nov 2020
Posts: 4
16NOV2020 is on a distinguished road
Default

Sorry.

Edited for me being a dunce...

Last edited by 16NOV2020; 11-17-2020 at 08:12 AM.
Reply With Quote
  #5  
Old 11-16-2020, 09:10 PM
Logit Logit is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Both of those downloads have a "Setup.exe" file. Neither has an Excel file.
Reply With Quote
  #6  
Old 11-16-2020, 11:11 PM
Purfleet Purfleet is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Yes that is what i got


Attached Images
File Type: jpg Screenshot 2020-11-17 061329.jpg (21.2 KB, 14 views)
Reply With Quote
  #7  
Old 11-17-2020, 08:15 AM
16NOV2020 16NOV2020 is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2019
Novice
USPS Intelligent Mail Encoder How to Remove Text from Column?
 
Join Date: Nov 2020
Posts: 4
16NOV2020 is on a distinguished road
Default

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...
Reply With Quote
  #8  
Old 11-17-2020, 08:30 AM
Purfleet Purfleet is offline USPS Intelligent Mail Encoder How to Remove Text from Column? Windows 10 USPS Intelligent Mail Encoder How to Remove Text from Column? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Okay, still struggling with outplaying with it, can you upload anyone. I might be able to install on my test machine
Reply With Quote
Reply

Thread Tools
Display Modes


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
USPS Intelligent Mail Encoder How to Remove Text from Column? Macro to remove blank column netchie Word VBA 4 03-14-2013 02:22 PM
USPS Intelligent Mail Encoder How to Remove Text from Column? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft