I would like to validate mailing addresses in my business contacts database.
I am familiar with VBA but don't know where to start with this.
Here is what I want to do:
1) Access the
www.usps.com/zip4/welcome.jsp website to bring up the page for
entering address information.
2) Plug in the address from the business contact manager address fields.
3) Parse the response from the web page for the valid address.
4) Replace the address in the business contact manager with the parsed
address.
Sample vba code would be appreciated.
Thank you in advance for any tips on how to tackle this problem.