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

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.