SendDateTime Property

Applies To

Mailer object.

Description

Returns the date and time that the mailer was sent. For this property to be valid, the mailer must have already been sent. Available only in Microsoft Excel for the Macintosh, with the PowerTalk mail system extension installed. Read-only Date.

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