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

Last reviewed: September 12, 1996
Article ID: Q109207
The information in this article applies to:
  • 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.

You will receive the following error message

   Another application has denied your request.

and Microsoft Mail will not sign out properly.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.