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