PDA

View Full Version : Web Query to grab zip codes from USPS



dmyro
08-09-2010, 08:47 AM
I have looked around to no success to find a function that grabs an address, city and state from my worksheet to populate a United States Postal Service web page and successfully return a zip code as a result. I have seen a variation on this site that uses a phone number to return a zip code but I need to be more site specific. The largest problem I had was figuring out how to send data to the required web page fields as I need to run this process hundreds of times a week so the automation would be a huge time saver. Any help in direction would be much appreciated.