Last active
          April 22, 2020 02:27 
        
      - 
      
 - 
        
Save kerrypnx/ad2cd04f7a6e6af34028487dac93f682 to your computer and use it in GitHub Desktop.  
    Trigger a macro to run after a new mail is received in Outlook
  
        
  
    
      This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
      Learn more about bidirectional Unicode characters
    
  
  
    
  | Option Explicit | |
| Private WithEvents inboxItems As Outlook.Items | |
| Private Sub Application_Startup() | |
| Dim outlookApp As Outlook.Application | |
| Dim objectNS As Outlook.NameSpace | |
| Set outlookApp = Outlook.Application | |
| Set objectNS = outlookApp.GetNamespace("MAPI") | |
| Set inboxItems = objectNS.GetDefaultFolder(olFolderInbox).Items | |
| End Sub | |
| Private Sub inboxItems_ItemAdd(ByVal Item As Object) | |
| On Error GoTo ErrorHandler | |
| Dim Msg As Outlook.MailItem | |
| Dim MessageInfo | |
| Dim Result | |
| If TypeName(Item) = "MailItem" Then | |
| MessageInfo = "" & _ | |
| "Sender : " & Item.SenderEmailAddress & vbCrLf & _ | |
| "Sent : " & Item.SentOn & vbCrLf & _ | |
| "Received : " & Item.ReceivedTime & vbCrLf & _ | |
| "Subject : " & Item.Subject & vbCrLf & _ | |
| "Size : " & Item.Size & vbCrLf & _ | |
| "Message Body : " & vbCrLf & Item.Body | |
| Result = MsgBox(MessageInfo, vbOKOnly, "New Message Received") | |
| End If | |
| ExitNewItem: | |
| Exit Sub | |
| ErrorHandler: | |
| MsgBox Err.Number & " - " & Err.Description | |
| Resume ExitNewItem | |
| End Sub | 
  
    Sign up for free
    to join this conversation on GitHub.
    Already have an account?
    Sign in to comment