Sender Property

Applies To

Mailer object.

Description

Returns the name of the user who sent this workbook mailer. Available only in Microsoft Excel for the Macintosh, with the PowerTalk mail system extension installed. Read-only String.

See Also

BCCRecipients property, CCRecipients property, Enclosures property, Mailer property, Received property, SendDateTime 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