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.

The VBA part reading and writing Contact address info is the easy part.
Automating filling out web applications forms in a browser is the very hard
part (meaning I'm not sure where to begin there). I suggest you find a web
development forum for that part, but if you have any questions about the
Outlook Object Model we're here to help.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"dbunhook" wrote:

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.