Public Sub ChkMail() Dim golApp As Outlook.Application Dim gnspNameSpace As Outlook.NameSpace Dim fldInbox As Outlook.MAPIFolder Dim i As Integer Set golApp = ThisOutlookSession Set gnspNameSpace = golApp.GetNamespace("MAPI") Set fldInbox = gnspNameSpace.GetDefaultFolder(olFolderInbox) For i = 1 To fldInbox.Items.Count With fldInbox.Items.Item(i) '--write you code to get body,subject etc. End With Next
Dim golApp As Outlook.Application
Dim gnspNameSpace As Outlook.NameSpace
Dim fldInbox As Outlook.MAPIFolder
Dim i As Integer Set golApp = ThisOutlookSession
Set gnspNameSpace = golApp.GetNamespace("MAPI")
Set fldInbox = gnspNameSpace.GetDefaultFolder(olFolderInbox)
For i = 1 To fldInbox.Items.Count
With fldInbox.Items.Item(i)
'--write you code to get body,subject etc. End With
Next