Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Richland, Washington, USA
    Thanked 0 Times in 0 Posts

    Outlook instance abnormally quits after Send

    Access 2007 SP2
    Outlook 2007 SP2

    I'm opening Outlook from Access VBA, composing an e-mail message, and then sending it. If I watch Processes in Task Manager, the instance gets created fine and I step throught the code to the .Send command. When I execute that command, Outlook terminates (it disappears from the Task Manager Processes list). If I open Outlook from the desktop, it's apparent that the e-mail did get sent before Outlook terminated. Since I want to send multiple e-mails, this presents a headache -- I don't want to re-create the Outlook object for each message!

    Curiously, if Outlook is already open before I execute this "send e-mail" code (I check for an existing instance in the code and open a new instance only if an existing instance is not found), everything works fine. It's only when I have to create the instance of Outlook in VBA that the "disappearing Outlook" problem described above raises its ugly head.

    Any thoughts on what might be causing (and how to avoid it!) this would be greatly appreciated!!



  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts
    I think we will need to see your code as to how you create the instance of Outlook when it isn't already open. There are at least a couple of methods for creating a new instance, and they have different behavior when doing things in Outlook. Also another question - the Outlook connected to Exchange? If so Outlook behaves in a different manner when sending.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts