PDA

View Full Version : excel & outlook express



lior03
05-19-2006, 05:42 AM
hello
is it possible to open outlook express from excel.
can i be notofied if a new e-mail message has arrive?
thanks

johnske
05-19-2006, 06:29 AM
Hi moshe,

1) Yes,
Option Explicit
'
Sub OpenOE()
'
On Error GoTo 1
ActiveWorkbook.FollowHyperlink _
"C:\Program Files\Outlook Express\msimn.exe", _
NewWindow:=True
'
1: MsgBox Err.Description
End Sub2) Not unless OE is open :)