Suburb and Zip code lookup

P

Phillip

Im trying to create a system that automatically enters a
zip code into a text field based on the contents of the
previous suburb field using a Word 2003 macro.

If anyone can help me with this would be most appreciated
am using Word 2003 beta.

Thanks for your help.
 
J

Jay Freedman

Hi, Phillip,

You're going to need some kind of data store that associates place names
with zip codes. You should probably think about using one that's accessible
through the Internet. I think the full database would be a bit large to
carry around. :)

If you're doing this for the USA only, you should visit the US Postal
Service's Web Tools API Center, http://164.109.64.170/front2.asp (you can
also get there by going to the manual Zip+4 lookup page,
http://www.usps.com/zip4/welcome.htm, and clicking the link at the bottom of
the page). This information should help you build a custom Smart Tag for
Office.

I haven't looked yet, but you may be able to hook into Microsoft MapPoint if
you have it.

In the UK, the Royal Mail has a postcode finder you can reach through
http://www.royalmail.com but they don't appear to offer any programmatic
access -- in fact, the manual version requires registration and a login.
The Australia Post offers a download of the entire postcode database from a
link on http://www1.auspost.com.au/postcodes/.

Until you know what data store you'll use and how to access it, there's no
point in talking about how to program the macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top