Mailer Property

Applies To

Workbook object.

Description

Returns a Mailer object that represents the PowerTalk mailer attached to the workbook. Available only in Microsoft Excel for the Macintosh, with the PowerTalk mail system extension installed. Read-only.

Remarks

The Mailer object contains the properties needed to mail workbooks with PowerTalk. To mail a workbook, turn on the mailer by using the HasMailer property, set the mailer properties, and then send the workbook and mailer by using the SendMailer method.

See Also

BCCRecipients property, CCRecipients property, Enclosures property, HasMailer property, Received property, SendDateTime property, Sender property, SendMailer method, Subject property, ToRecipients property.

Example

This example sets up the Mailer object for workbook one and then sends the workbook.

With Workbooks(1)
    .HasMailer = True
    With .Mailer
        .Subject = "Here is the workbook"
        .ToRecipients = Array("Jean")
        .CCRecipients = Array("Adam", "Bernard")
        .BCCRecipients = Array("Chris")
        .Enclosures = Array("TestFile")
    End With
    .SendMailer
End With