Expert Ron Needed....

[teamgoldusa]

Ron,

I remember you had previously written a excel script that did a zip code look up from the web for verification of zip,city.

My sample data example...

Jane W Doe 1159 Holman Road Oakland CA 94610
Jane W Doe 1178 Tiegen Drive Hayward CA 94542
Jane W Doe 12 Observation Pl Oakland CA 94611
Jane W Doe 1207-1209 54Th Street Emeryville CA 94608
Jane W Doe 1244 Georgetown Ave San Leandro CA 94579
Jane W Doe 1257 103Rd Avenue Oakland CA 94603


I need to end up with five columns...name ...address...city...state...zip

Thank you in advance for any help.

MAS

 

[Ron Rosenfeld]

Ron,

I remember you had previously written a excel script that did a zip code look up from the web for verification of zip,city.

My sample data example...

Jane W Doe 1159 Holman Road Oakland CA 94610
Jane W Doe 1178 Tiegen Drive Hayward CA 94542
Jane W Doe 12 Observation Pl Oakland CA 94611
Jane W Doe 1207-1209 54Th Street Emeryville CA 94608
Jane W Doe 1244 Georgetown Ave San Leandro CA 94579
Jane W Doe 1257 103Rd Avenue Oakland CA 94603


I need to end up with five columns...name ...address...city...state...zip

Thank you in advance for any help.

MAS

If you are going to be processing more than just a trivial number of addresses, that script will not be too useful as it does a "one at a time" lookup and will take quite a bit of time to run. You'd be better served by obtaining a data base that you can keep on your own computer/network.

Also, something has changed, either in IE or at the USPS web site, and the code as originally written is no longer functional.
If you need "up to the minute" data, you'll probably have to purchase a database. If you can get by with less regular updates, I found this free one at http://federalgovernmentzipcodes.us/