>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.

I don't know of a tool, but I know the FCC website does it. You can modify the city and state in this url and get the latitude and longitude:

http://www.fcc.gov/cgi-bin/atlas?city=FAYETTEVILLE&state=NC