Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    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!!

    Thanks,

    Tom

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,481
    Thanks
    3
    Thanked 41 Times in 41 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.
    Wendell

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
  •