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
How to add "Copy to" and "Move to" options to the right-click context menu in Windows:
Method 1: Registry Editor (Manual) Note: Back up your registry first or create a system restore point. Add "Copy to" Option:...
-
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 : ...
-
Adding Project Items The following tables list the available project items for local and Web projects. Note that for some project items, th...
No comments:
Post a Comment
Thank you for Commenting Will reply soon ......