Programming Excel with VBA and .NET

MailItem Members

Use the MailItem object to set the attributes of the email sent using the MsoEnvelope object. Use the MsoEnvelope object’s Item property to get a reference to this object. The MailItem object has the following members . MailItem is part of the Outlook object library and many of the members don’t apply within Excel. Key members that are of use from within Excel (shown in bold) are covered in the following reference section:

Warning

To declare a variable as a MailItem object, you must first add a reference to the Microsoft Outlook type library.

Actions	AlternateRecipientAllowed
Application	Attachments
AutoForwarded	AutoResolvedWinner
BCC	BillingInformation
Body	BodyFormat
Categories	CC
Class	ClearConversationIndex
Close	Companies
Conflicts	ConversationIndex
ConversationTopic	Copy
CreationTime	DeferredDeliveryTime
Delete	DeleteAfterSubmit
Display	DownloadState
EnableSharedAttachments	EntryID
ExpiryTime	FlagDueBy
FlagIcon	FlagRequest
FlagStatus	FormDescription
Forward	GetInspector
HasCoverSheet	HTMLBody
Importance	InternetCodepage
IsConflict	IsIPFax
ItemProperties	LastModificationTime
Links	MarkForDownload
MessageClass	Mileage
Move	NoAging
OriginatorDeliveryReportRequested	OutlookInternalVersion
OutlookVersion	Parent
Permission	PermissionService
PrintOut