• Subject: run macro when mail received
  • Author: jason
  • Date: 09 Feb 2010
  • References:
thank in advance.

i am using the below code referenced directly from msdn (http://
msdn.microsoft.com/en-us/library/aa171307(office.11).aspx)

but it does not seem to be working. I created and placed in a class
file as directed.

any help on (if there exists) a simpler way to code this or a way to
get this work would be a great help.


thank you!
-------

Public WithEvents myOlApp As Outlook.Application

Sub Initialize_handler()
Set myOlApp = CreateObject("Outlook.Application")
End Sub

Private Sub myOlApp_NewMail()
Dim myExplorers As Outlook.Explorers
Dim myFolder As Outlook.MAPIFolder
Dim x As Integer
Set myExplorers = myOlApp.Explorers
Set myFolder =
myOlApp.GetNamespace("MAPI").GetDefaultFolder(olFolderInbox)
If myExplorers.Count <> 0 Then
For x = 1 To myExplorers.Count
On Error GoTo skipif
If myExplorers.Item(x).CurrentFolder.Name = "Inbox" Then
myExplorers.Item(x).Display
myExplorers.Item(x).Activate
Exit Sub
End If
skipif:
Next x
End If
On Error GoTo 0
myFolder.Display
End Sub
09 Feb 2010run macro when mail received.jason
09 Feb 2010\ Re: run macro when mail received.Sue Mosher [MVP]
09 Feb 2010   \ Re: run macro when mail received.jason
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)