Copy information from a Microsoft Office document

You can copy location information from many Microsoft Office programs for use on a map. For example, you can copy addresses or tables from Microsoft Office Word, queries or tables from Microsoft Office Access, and spreadsheets from Microsoft Office Excel.

  1. Open the Microsoft Office document that contains the information you want to copy.

  2. Select the location information:

    • In Office Word, select the text or table that contains location information.

    • In Office Excel, select the cells that contain location information.

    • In Office Access, select the records that contain location information.

  3. On the Edit menu of the Microsoft Office program, click Copy.

  4. In MapPoint, click the map to select it, and then on the Edit menu, click Paste.

    The Import Data Wizard starts. This wizard guides you through the steps of importing data from the source file to display it on your map.

Notes

  • Before copying information from Microsoft Office Excel or Access, make sure that your data is properly formatted.

    How?

  • To start planning a route for an address in Microsoft Office Word 2007 or later, select the address, click the Add-Ins menu (in Word 2007 or later), and then click Plan route in MapPoint. MapPoint automatically opens, adds a pushpin to mark the address on the map, and then adds the address a stop in the Route planner.

    If you have the English version of Microsoft Office Word 2007 installed, you can also use smart tags to start planning your route.

  • Another way to export or link data from Microsoft Office Excel is to select the data you want to export or link, and then on the Add-Ins menu (in Excel 2007 or later), click Export to MapPoint or Link to MapPoint. MapPoint automatically opens and starts the Import data wizard or Link data wizard.

    If you have the English version of Microsoft Office Excel 2007 installed, you can also use smart tags to export or link data from Excel.

    Another quick method to link to data is to select and copy the cells from a saved worksheet in Excel, and then in MapPoint, click the map to select it, and on the Edit menu, click Paste Link.

  • You can also import or link location information to MapPoint without opening the Microsoft Office program by using the Import data wizard or Link data wizard.

Related topics

Show: