XL2002: "Send To Routing Recipient" Does Not Work (296396)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q296396

SYMPTOMS

When you try to route a workbook in Microsoft Excel, you may experience one of the following symptoms:
  • On the FIle menu, when you point to Send To, and then click Routing Recipient, nothing happens.
  • On the File menu, when you point to Send To, and then click Routing Recipient (as Attachment), the command is not available.
  • When you try to use the "SendMail" function in a Microsoft Visual Basic for Applications (VBA) macro, you receive the following error message:
    Run-time error '1004': Method 'SendMail' of object '_Workbook' failed.

CAUSE

This behavior may occur when the following entry is missing from the [Mail] section of the Win.ini system file:

MAPIX=1

RESOLUTION

To resolve this behavior, add the MAPIX=1 entry to the Win.ini file. To do this, follow these steps:
  1. Click Start, and then click Run.
  2. In the Open box, type Sysedit, and then click OK.
  3. In System Configuration Editor, click the title bar of the drive:\WINDOWS\WIN.INI window, where drive is the drive on which Microsoft Windows is installed.
  4. Scroll down to the [Mail] section of the Win.ini file.
  5. Under [Mail], type a new line that reads MAPIX=1, and then press ENTER.
  6. On the File menu, click Exit.
Modification Type:MinorLast Reviewed:7/27/2006
Keywords:kbprb KB296396
©2004 Microsoft Corporation. All rights reserved.