The "Pushpin Tool" add-in was originally designed to do this (more features were added later) easily for end-users. $75

Otherwise it is not so much programming to do it via Excel VBA or anything else that can automate MapPoint.

Eric