SendDateTime Property

Applies To

Mailer Object.

Description

Returns the date and time that the mailer was sent. The mailer must be sent before this property is valid. Available only in Microsoft Excel for the Apple Macintosh with the PowerTalk mail system extension installed. Read-only.

See Also

BCCRecipients Property, CCRecipients Property, Enclosures Property, Mailer Property, Received Property, Sender Property, SendMailer Method, Subject Property, ToRecipients Property.

Example

This example displays the sender of the workbook, plus the date and time it was sent.

If ActiveWorkbook.HasMailer Then
    MsgBox "This workbook was sent by " & _
        ActiveWorkbook.Mailer.Sender & " at " & _
        Format(ActiveWorkbook.Mailer.SendDateTime, "General Date")
End If