Results 1 to 2 of 2

Thread: Word ZipCoder??

  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Milwaukee, Wisconsin, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word ZipCoder??

    Well....since the WOPR ZipCode+4 is broken, and there is no fix on the horizon....Are there any other MSWord add-in programs that will go to the US Post Office website and return the ZIP+4 information? Thanks.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Word ZipCoder??

    The USPS now has an XML-based Zip-code-retrieval and address-verification interface, which you can learn more about here: http://www.usps.com/webtools/. Because that requires each user or company to have its own user id and password, it probably is not a quick VBA solution.

    It still might be possible to program the JSP-based web pages that start at http://zip4.usps.com/zip4/welcome.htm, but it's a chore dealing with IE's document object model to populate the fields, submit the form, and then read the results. I'm not sure if it's any faster to use the downloadable USPS Shipping Assistant software.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •