To determine approximate distance between clients and employees, the need to calculate this knowing the latitude and longitude coordinates of our clients and employees.

Used the routine that Craig Boyd has to find Latitude and Longitude from "geocoder" for all of our clients and employees and was successful for about 85% of the 8400 address locations we have. I am assuming that the address information for those 15% is not being recognized because of user putting such things as Box numbers, Apt. numbers etc.

So i thought for these, that I could simply get an approximate Lat and Long based only on the Town name with out an address. However, this does not work.

Does anyone have suggestions on how one can get the Lat and Long for each town with out an address?

Thanks in advance.