Pull USPS address to excel

Hi Experts,

I'm looking for your help to get the address from USPS.com ( https://tools.usps.com/go/ZipLookupAction!input.action)

I have the Street Address in Range "A1" and City in "A2" and State in "A3" and ZIP in "A4"

I need to validate the address with USPS.com

So I am looking for VBA code to open the USPS site and enter the the data as mentioned in Range A1,A2,A3,A4 and retrive the correct address in Range B1,B2,B3,B4

Is this Possible. Looking for your advice.

Thanks in advance,
Sakthivel

got the codes

I'm Ready
But I'm new to this kind of websites . so how to Code in Code Tags ?

I did code Tags

I am using Excel 2013 and I am having some issues with the code.
Dim IE As New InternetExplorer: Compile Error: User-defined type not defined (So I commented this out and it seemed to work)
zipcode.Item(0).Value = myzip: Run-time error'91': Object variable or With block not set

Would you be able to post an xlsm file that has the code in it and working?

Thought I'd share and pay the good work done thus far forward for the next person looking to validate some addresses. I had about 1000 addresses to validate (all in A-E). Code below runs through rows that you specifiy (see For r = xxx to xxx) returns the validated address (if found) back to (G-K). The USPS web times out after every so often, but I just re-sort the blanks to the bottom, change the rows, and re-run.

Thanks for this forum/thread...

Please Login or Register  to view this content.

Thanks for the updated code fastintruder.

They updated the site and I'm trying to work thru the changes.

I updated:

R value

Commented out state since its now a drop down and not necessary.

Removed ' from zip, updated new name

Updated new button name

So it all works to grab info from excel, go to ie, enter address and validate it. It shows validated address but it's not in a format I'm not sure how to get that back to excel?

Any thoughts?

No problem I can start a new post.

Just didnt feel like i violated anything. My post is nothing new and is 100% related to the OPs post. Its just the USPS website has changed. Seems to me the up to date code for the OPs post would be perfect for this thread.

No problem though

Hi Experts,
I want to validate 340 addresses from USPS.
My excel sheet contains header as fllows:
A1- Street
B2-City
C3- State
D4- ZIP

Could you please send me codes.

Regards,
Sunil

Hi,

just well read post #13 …