OT: Address & ZIP Code Validation
Robert Hutchins
>With apologies for being OT . . .
Does anyone know if a reasonably priced option exists for validating street addresses and ZIP-codes? I have several fairly large address lists - up to about 550 names - that I keep for various organizations I belong to. I've been going thru them doing a sniff test for validity and find that quite a few have invalid ZIP codes. These lists were first compiled on handwritten index cards more than 40 years ago, then typed (yes, on a typewriter), and then entered on a computer. They were given to me 'as is' in an MSWord document to maintain. I've managed to get them arranged into Excel spreadsheet with appropriate data separated into columns.
I'd like to go through a validation process but don't mail to the lists often enough to justify the cost of CASS certification or tools. Going through them one at a time on the USPS ZIP code verification site will take longer than I've got - and will probably result in all kinds of phat phinger errors on my part. The organizations are church, civic club, high school class - that sort of thing. No one wants to spend much money for this, but I thought I'd seek the collective knowledge and wisdom here. Couldn't find anything that I thought would work googling, and couldn't get thru to anyone who could answer my questions at the local USPS office.
TIA



