Use MapPoint smart tags in Microsoft Word 2007 or Microsoft Excel 2007

Smart tags are a Word and Excel feature that automatically recognizes text or data as being of a certain type. The MapPoint smart tags recognize data as being a place or address and allow you to use the smart tags feature to quickly access functionality in MapPoint. When you install MapPoint, the MapPoint smart tags are available for use in Word and Excel.

Smart tag in Microsoft Word

Gg650228.BIZSmartTagWord(en-us,MSDN.10).gif

Smart tag in Microsoft Excel

Gg650228.BIZSmartTagExcel(en-us,MSDN.10).gif

When smart tags recognize text or data as being an address or place, in Word the text is underlined in purple and in Excel the cell in which the data appears has a purple triangle in the lower-right corner. When you place your mouse pointer over this text, the Smart Tag button appears. Click the arrow on the button to then select from the available actions on the list.

MapPoint smart tag action

In this program

Does this

Insert a MapPoint map

Word and Excel

Embeds a MapPoint map of the address or place after the text in your Word document or in the next empty cell in your Excel spreadsheet.

Plan Route in MapPoint

Word

Opens MapPoint, adds a Pushpin to mark the address or place on the map, and then adds it as a stop in the Route Planner.

Export Data to MapPoint

Excel

Opens MapPoint and starts the Import Data Wizard, which guides you through the steps of importing data from the source file to display the data on your map.

Link Data To MapPoint

Excel

Opens MapPoint and starts the Link Data Wizard, which guides you through the steps of linking data from the source file to display the data on your map.

To enable MapPoint smart tags

In Microsoft Office Word 2007

  1. Open Microsoft Office Word.

  2. Click the Office Button in the upper-left corner of the screen, and then click Word Options.

  3. In the left pane, click Proofing.

  4. Click AutoCorrect Options.

  5. In the AutoCorrect dialog box, click the Smart Tags tab.

  6. On the Smart Tags tab, do either or both of the following:

    • To have smart tags recognize addresses, select the Addresses (English) check box.

    • To have smart tags recognize places, select the Places (English) check box.

  7. Click OK.

In Microsoft Office Excel 2007

  1. Open Microsoft Office Excel.

  2. Click the Office Button in the upper-left corner of the screen, and then click Excel Options.

  3. In the left pane, click Proofing.

  4. Click AutoCorrect Options.

  5. In the AutoCorrect dialog box, click the Smart Tags tab.

  6. On the Smart Tags tab, select the MapPoint location headings check box.

  7. Click OK.

To remove MapPoint smart tags

In Microsoft Office Word 2007

  1. Open Microsoft Office Word.

  2. Click the Office Button in the upper-left corner of the screen, and then click Word Options.

  3. In the left pane, click Proofing.

  4. Click AutoCorrect Options.

  5. In the AutoCorrect dialog box, click the Smart Tags tab.

  6. On the Smart Tags tab, do either or both of the following:

    • Clear the Address (English) check box to stop recognizing addresses.

    • Clear the Places (English) check box to stop recognizing places.

  7. Click OK.

In Microsoft Office Excel 2007

  1. Open Microsoft Office Excel.

  2. Click the Office Button in the upper-left corner of the screen, and then click Excel Options.

  3. In the left pane, click Proofing.

  4. Click AutoCorrect Options.

  5. In the AutoCorrect dialog box, click the Smart Tags tab.

  6. On the Smart Tags tab, clear the MapPoint location headings check box.

  7. Click OK.

Notes

  • Smart tags work independently of the MapPoint Office COM add-in but have similar functionality. When data in your Excel spreadsheet contains multiple addresses, it may be more convenient to work with the MapPoint Office COM add-in because you can export or link multiple cells to MapPoint.

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

    How?

  • MapPoint smart tags also work in Microsoft Internet Explorer version 5.5 and higher when displaying a Web page saved from a Word document. When saving your Word document, make sure that the smart tags are saved as XML properties.

Related Topics

Show: