XL2002: "Send To Routing Recipient" Does Not Work

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.

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

MAPIX=1

To resolve this behavior, add the MAPIX=1 entry to the Win.ini file. To do this, follow these steps:

Click Start, and then click Run.
In the Open box, type Sysedit, and then click OK.
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.
Scroll down to the [Mail] section of the Win.ini file.
Under [Mail], type a new line that reads MAPIX=1, and then press ENTER.
On the File menu, click Exit.