Microsoft KB Archive/296396

= XL2002: &quot;Send To Routing Recipient&quot; Does Not Work =

Article ID: 296396

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



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 &quot;SendMail&quot; 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  :\WINDOWS\WIN.INI window, where   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.

Keywords: kbprb KB296396

-

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

© Microsoft Corporation. All rights reserved.