Microsoft KB Archive/292474

= XL2002: Address Is Not Inserted into Worksheet When You Click &quot;Insert Address&quot; on Smart Tag Menu =

Article ID: 292474

Article Last Modified on 5/21/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



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 &quot;Symptoms&quot; 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

Additional query words: XL2002 prb

Keywords: kberrmsg kbpending kbprb KB292474

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.