+ Reply to Thread
Results 1 to 4 of 4

Check to see if outlook is open

  1. #1
    Forum Contributor
    Join Date
    01-18-2005
    Posts
    238

    Check to see if outlook is open

    Is there a simple way to see if outlook is currently open, if not then open it.


    I was trying something like this, but it didn't work, and I have the outlook library checked


    Please Login or Register  to view this content.

    thanks for any help


    Josh

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Josh,

    This code snippet uses late binding to create an instance of Outlook if it isn't running. This way the end-user doesn't have to have a library reference set in their VBA project for the code to work.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross
    Last edited by Leith Ross; 08-14-2007 at 08:07 PM.

  3. #3
    Forum Contributor
    Join Date
    01-18-2005
    Posts
    238

    I can't get it to work

    Thanks Leith for the reply, but for some reason, it looks like the code is thinking but it won't load outlook, if outlook isn't currently open.


    thanks

    Josh

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Josh,

    Can you post the macro code you have? I have used this code routine many times with no problems. If you want Outlook to be visible when started then add this line of code after the If...Else...Then statement.

    Another thing to look at is security. Firewalls and anti virus software cab interfere or block these type of scripts.
    Please Login or Register  to view this content.
    Thanks,
    Leith Ross
    Last edited by Leith Ross; 08-15-2007 at 02:33 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1