XL5: Can't Sign Out of Microsoft Mail After Routing Document

• Microsoft Excel for Windows, version 5.0

SUMMARY

If you route a document from Microsoft Excel for Windows version 5.0 by choosing the Add Routing Slip command on the File menu, you may receive an error message if you choose the Exit And Sign Out command in Microsoft Mail before you close Microsoft Excel.

NOTE: Only the Exit And Sign Out command produces the error message. You can choose the Exit command in Microsoft Mail without receiving an error message.

MORE INFORMATION

This error message occurs because, when you route a document, Microsoft Excel links to the dynamic link libraries (DLLs) used by Microsoft Mail to send and receive messages. Microsoft Excel retains the link to the MS Mail DLLs until you do either of the following:

• In Microsoft Excel, choose Exit from the File menu: when you use the Exit command in Microsoft Excel, you will be able to use the Exit And Sign Out command in MS Mail.

  -or-

• Use the Visual Basic Application.MailLogoff macro command to force Microsoft Excel to disconnect from the MS Mail DLLs.

  NOTE: If you use this command when you have not routed a document or otherwise connected Microsoft Excel to MS Mail, you will receive the error message

        Run-time error '1004':
        MailLogoff method of Application class failed
  

Steps to Reproduce Behavior

1. In a new worksheet in a new workbook, enter the following values:

   A1: Alpha A2: Bravo A3: Charlie

2. Save the workbook as ROUTED.XLS.

3. From the File menu, choose Add Routing Slip.

4. In the Routing Slip dialog box, choose Address.

5. Enter your electronic mail name in the To box. Choose OK.

6. Choose the Add Slip button.

7. As soon as the Routing Slip dialog box disappears, switch to the Microsoft Mail application.

8. From the File menu, choose the Exit And Sign Out command.

   Another application has denied your request.