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.
