As well as John Meyer's Batch Calculator, I have "MileCharter":
http://www.mapping-tools.com/milecharter/index.shtml
This can work between two different groups, outputting a table to Excel.
Fastest route, shortest route, straight line, etc
out of the box it won't automatically identify the closest or shortest, but if you want this, send a message off-list.
Richard