Consulting

Results 1 to 2 of 2

Thread: excel & outlook express

  1. #1
    VBAX Mentor
    Joined
    Jun 2005
    Posts
    374
    Location

    excel & outlook express

    hello
    is it possible to open outlook express from excel.
    can i be notofied if a new e-mail message has arrive?
    thanks
    moshe

  2. #2
    Administrator
    Chat VP
    VBAX Guru johnske's Avatar
    Joined
    Jul 2004
    Location
    Townsville, Australia
    Posts
    2,872
    Location
    Hi moshe,

    1) Yes,
    [vba]Option Explicit
    '
    Sub OpenOE()
    '
    On Error GoTo 1
    ActiveWorkbook.FollowHyperlink _
    "C:\Program Files\Outlook Express\msimn.exe", _
    NewWindow:=True
    '
    1: MsgBox Err.Description
    End Sub[/vba]2) Not unless OE is open
    You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you

    The major part of getting the right answer lies in asking the right question...


    Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.

Posting Permissions

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