Here's a preliminary copy of a tool I'm working on to generate a list of the points of interest around an area.

Instructions:

Open MapPoint and go to View | Show or Hide Places to turn on/off the POI's you want.

Run the macro in the attached spreadsheet by going to Tools | Macros.

A list will be generated in Excel for all the POI's.

(Note that it's currently hard coded to do a single lat/lon 40, -90. This can be adjusted in the code.)

The tool is based roughly on this article --
Extracting the Mappoint 2002 Points of Interest - MapPoint Articles - MP2K Magazine

Note that if you want to extract a large area or ALL the POI's in MapPoint, it does make more sense to export to a database than Excel as the article is written. A database can do automatic deduping (set a unique key on a few columns such as name/lat/lon/category) and does not have a row limit.

Eric

Fixed a couple minor things, new file attached above.

Eric