Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Want Better Milling & Firewood Knowledge?

OT: Address & ZIP Code Validation

Posts

OT: Address & ZIP Code Validation

#1

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

Re: OT: Address & ZIP Code Validation

#2

Re: OT: Address & ZIP Code Validation

Kneale Brownson in Northern MI

>The Post Office sells a printed current zip code listing (couple of huge books printed on thin paper) that tells which zip codes go with which street numbers.

Re: OT: Address & ZIP Code Validation

#3

Re: OT: Address & ZIP Code Validation

Tom Dunlap

>I think that the USPS will sanitize the list for you. It seems to stick in my mind, along with some rather useless detritus, that they will do it for free.

Re: OT: Address & ZIP Code Validation

#4

Re: OT: Address & ZIP Code Validation *LINK*

Ron in Drums PA

>It would probably cost about $100-$150 to get a list of 600 addresses cleaned up.

Here is a simple way to do it yourself. Below the return address add this line "Address Service Requested."

The mail piece will be forwarded and you will receive a post card with the corrected address.

Below is a link with all the details


http://www.usps.com/ncsc/addressservices/moveupdat

Re: OT: Address & ZIP Code Validation

#5

Re: OT: Address & ZIP Code Validation

Howard Norman-Prescott, AZ

>Ron, the address return system only works for first class mail. A lot of bulk mailings are made at bulk rates where the address return system does not apply. Two years ago I was involved in a local political effort and we had yhis issue. Our solution was to make one first class mailing to clean up the list and then revert to bulk mailing postage.

Howard

Re: OT: Address & ZIP Code Validation

#6

Re: OT: Address & ZIP Code Validation *LINK*

Ron in Drums PA

>It works for all types of mail


http://pe.usps.gov/text/qsg300/Q507d.htm

Re: OT: Address & ZIP Code Validation

#7

Thanks, Guys! But What I'm Looking for . . .

Robert Hutchins

>. . . is someplace I can send a file, have it validated against a list of street addresses for the city and have the ZIP+4 code returned with the list. Dealing with near a thousand addresses - many of which I know have incorrect ZIPs - could be a bit more than I can handle manually and maintain the integrity of the lists.

Re: OT: Address & ZIP Code Validation

#8

Re: OT: Address & ZIP Code Validation

Howard Norman-Prescott, AZ

>Not according to our local post office, only first class.

Re: OT: Address & ZIP Code Validation

#9

Tell them to RTM

Ron in Drums PA

>

Re: OT: Address & ZIP Code Validation

#10

Re: OT: Address & ZIP Code Validation

Barry Irby

>Robert, I found that about 15 to 20% of addresses "deteriorate" every year. If parts of your list are forty years old.....wow!

One thing we did was to send a post card to everyone with the address correct notice on it. At the time they were only 22 cents each and we got back the ones that did not go through. I know that's not what you were asking, but it�s cheaper than sending a letter. There might be a fee for each one returned, but as I recall, that was for bulk mail with return service. We used to buy lists and as many as a third of them would come back.

UPS (Brown, not USPS) has a web site for shipping. One of the things it does is address verification. A very patient person could enter them one at a time and check them. (cut, paste, cut paste....)

Another thought is to find a local mail house. They handle your bulk mail for you. They would have the CASS software. Maybe you could sweet talk one of them into running your list through their soft ware and give it back to you in a format you could handle.

I also seem to recall that the Post Office would do it free and give it back to you in the exact format they want. (all caps, no commas, correct abbreviations, etc.)