Outlook – Mail item properties using VBA

Mail item properties using VBA in Outlook

If you are using VBA to look at mail properties it can get confusing pretty quick. How many properties do mail items have and which one should I use? Look no further. Here are some 90+ properties of a mail object in Outlook 2010.

0-Application
1-Class
2-Session
3-Parent
4-Actions
5-Attachments
6-BillingInformation
7-Body
8-Categories
9-Companies
10-ConversationIndex
11-ConversationTopic
12-CreationTime
13-EntryID
14-FormDescription
15-GetInspector
16-Importance
17-LastModificationTime
18-MessageClass
19-Mileage
20-NoAging
21-OutlookInternalVersion
22-OutlookVersion
23-Saved
24-Sensitivity
25-Size
26-Subject
27-UnRead
28-UserProperties
29-AlternateRecipientAllowed
30-AutoForwarded
31-BCC
32-CC
33-DeferredDeliveryTime
34-DeleteAfterSubmit
35-ExpiryTime
36-FlagRequest
37-HTMLBody
38-OriginatorDeliveryReportRequested
39-ReadReceiptRequested
40-ReceivedByEntryID
41-ReceivedByName
42-ReceivedOnBehalfOfEntryID
43-ReceivedOnBehalfOfName
44-ReceivedTime
45-RecipientReassignmentProhibited
46-Recipients
47-ReminderOverrideDefault
48-ReminderPlaySound
49-ReminderSet
50-ReminderSoundFile
51-ReminderTime
52-RemoteStatus
53-ReplyRecipientNames
54-ReplyRecipients
55-SaveSentMessageFolder
56-SenderName
57-Sent
58-SentOn
59-SentOnBehalfOfName
60-Submitted
61-To
62-VotingOptions
63-VotingResponse
64-Links
65-ItemProperties
66-BodyFormat
67-DownloadState
68-InternetCodepage
69-MarkForDownload
70-IsConflict
71-AutoResolvedWinner
72-Conflicts
73-SenderEmailAddress
74-SenderEmailType
75-Permission
76-PermissionService
77-PropertyAccessor
78-SendUsingAccount
79-TaskSubject
80-TaskDueDate
81-TaskStartDate
82-TaskCompletedDate
83-ToDoTaskOrdinal
84-IsMarkedAsTask
85-ConversationID
86-Sender
87-PermissionTemplateGuid
88-RTFBody
89-RetentionPolicyName
90-RetentionExpirationDate

Some interesting properties are:

  • CreationTime
  • LastModificationTime
  • SentOn
  • ReceivedTime
  • Subject
  • SenderName
  • To
  • CC
  • BCC