I used this code a few years ago when one of our customers asked us to be able to enter the zip code and the corresponding City and State would be entered automatically.  I have not had this request brought up to me until last week, when one of our customers switching to Synergy for their CRM said that this was a function of their old CRM package.

I found the code, which is a series of SQL scripts that run against the Synergy Enterprise database.  There is one script for the US Zip Code database and 16 scripts for the Canadian postal codes  These are the only two countries supported for this functionality that I am aware of.

When entering the zip code, you can only for the US database use the 5 digit format, not the 5+4.

You may find these scripts at Exact’s web site: