<div>
Hi<br />
<br />
As a starting point your going to need to look at the Microsoft Office XML Toolkit to programatically access the webservice from VBA, msdn has some articles.<br />
<br />
Hope this helps<br />
<br />
Regards<br />
<br />
Gary
</div>


Hi

As a starting point your going to need to look at the Microsoft Office XML Toolkit to programatically access the webservice from VBA, msdn has some articles.

Hope this helps

Regards

Gary

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
Has anyone developed any code to query the USPS API to lookup the zip+4 given just the street address, city &amp;&nbsp;state?<br />
<br />
I can make my way around access vba but haven't used xml etc.<br />
<br />
Thanks for the input!<br />
<br />
Deedub84
</div>
</div>


Hi Experts,

Has anyone developed any code to query the USPS API to lookup the zip+4 given just the street address, city & state?

I can make my way around access vba but haven't used xml etc.

Thanks for the input!

Deedub84

Querying the USPS zipcode lookup API from Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.