Hi! I work for a nationwide chain of health centers. We have many national clients with locations all over. We need to find the closest clinic to each client's locations, displaying mileage, and export the data to Excel. The process needs to be automated, since the Excel lists can be over 1000 locations sometimes.
We currently use MapInfo/MapMarker for this, but it's too expensive to renew our license. I was wondering if this process can be done in MapPoint, maybe with a little programming. It'd be great if we could do this without a full-blown GIS with features we don't need. If MapPoint won't work for this, any suggestions on what will?
Thanks for any help!