Public WithEvents myOlApp As Outlook.Application
Sub Initialize_handler()
Set myOlApp = Outlook.Application
End Sub
Private Sub myOlApp_NewMail()
Dim myExplorers As Outlook.Explorers
Dim myFolder As Outlook.Folder
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 SubAll the question that scared me now i am trying to scare them .. so that they cant scare others :)
Tuesday, October 18, 2011
Application.NewMail Event
Subscribe to:
Post Comments (Atom)
Featured Posts
✨ Tired of the same old Windows Start Menu and Taskbar?
✨ Tired of the same old Windows Start Menu and Taskbar? In this video, I’ll show you how to completely customize your Windows experience ...
-
Configuration config = HBaseConfiguration.create(); Job job = new Job(config,"ExampleReadWrite"); job.setJarByClass(MyReadWriteJo...
-
Use the following function which is built in percentile(BIGINT col, p) and set p to be 0.5 and will calculate the median credit : ...
No comments:
Post a Comment
Thank you for Commenting Will reply soon ......