+ Reply to Thread
Results 1 to 4 of 4

Open Outlook Once

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Open Outlook Once

    Is there a way so Outlook will only open once,so if it open then code does nothing ? Code works but opens Outlook every time its clicked.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Open Outlook Once

    check http://www.rondebruin.nl/win/s1/outlook/openclose.htm
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Open Outlook Once

    Not seeing anything on my problem?

  4. #4
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Open Outlook Once

    Quote Originally Posted by zplugger View Post
    Not seeing anything on my problem?
    Did you open it at all? You are using late binding and there is example code how to test if outlook is open and if yes - get it, if not - open it. Also note that what you want is way easier with early binding. Example - also in the link.
    Last edited by buran; 01-19-2017 at 12:37 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open Outlook
    By BigPaulMc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2016, 02:08 PM
  2. Outlook attachment Open
    By namluke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2014, 06:21 AM
  3. How to open and Close ms outlook??
    By uttam.mothe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2014, 09:12 PM
  4. outlook redemtion macro cant send mail if outlook is not open ?
    By okl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2010, 07:35 AM
  5. Open Outlook from Excel
    By littlethief in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-18-2008, 02:43 PM
  6. [SOLVED] excel open in outlook if outlook is running
    By kirk in forum Excel General
    Replies: 0
    Last Post: 05-24-2006, 01:45 PM
  7. [SOLVED] Open Outlook
    By JEFF in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2005, 05:05 AM

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