XL2002: Address Is Not Inserted into Worksheet When You Click "Insert Address" on Smart Tag Menu (292474)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q292474

SYMPTOMS

When you type the name of a Microsoft Outlook contact into a Microsoft Excel worksheet cell, and then click Insert Address on the smart tag button that appears, the address of that contact is not inserted into the worksheet as expected. If the name is a contact in the local Outlook Contacts folder, the contact is displayed. If not, you receive the following error message:
Microsoft Outlook could not find the requested contact.

CAUSE

This behavior occurs because the smart tag cannot insert the contact address into an Excel worksheet.

WORKAROUND

To work around this issue, copy and paste the information that you want if the contact appears when you click Insert Address. The contact appears only if the name recognized by the smart tag exists in the local Contacts folder in Microsoft Outlook 2002.

MORE INFORMATION

When you click the Insert Address command on the smart tag menu, the following behavior occurs:
  • If the name is found in the Outlook Contacts list, the contact item is displayed. You may copy and paste the contact information into Excel.
  • If the name is not found in the Outlook Contacts list, you receive the error message listed in the "Symptoms" section of this article.

    NOTE: This behavior occurs when you send e-mail to a recipient that is not listed in the Outlook Contacts list and then type that e-mail address into Microsoft Excel 2002.
NOTE: The address is inserted into the document when this smart tag menu command is selected in Microsoft Word 2002.

For additional information about using smart tags with e-mail recipients, click the article number below to view the article in the Microsoft Knowledge Base:

286832 Smart Tag Does Not Recognize Recent Outlook E-mail Recipients

Modification Type:MajorLast Reviewed:9/28/2001
Keywords:kberrmsg kbprb KB292474
©2002 Microsoft Corporation. All rights reserved.