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 Sub
All 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
Run Commands for Windows
🖥️ CPL Files (Control Panel Applets) Run via Win + R → filename.cpl Command Opens appwiz.cpl P...
-
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 ......