We are trying to use MapPoint for routing delivery vehicles, however, we are encountering another problem. After we optimize the route, we then
highlight all the pushpins and right click to export the data Excel, the
resulting table is NOT in the optimized order. Can anyone tell us how to
export the data in the "optimized" order?

Hi,

If you are still interested, I have a commandline utility st2gpx that may help. It can extract the data from your saved mappoint file into GPX format (there is a second tool that can convert this to csv for Excel if needed).

This would give you the waypoint data for the route in the calculated order, as well as other info.

You can find st2gpx at http://sourceforge.net/projects/gpsbabel

Let me know if you need help with this.

Cheers,
James