SendMailer Method

Applies To

Workbook object.

Description

Sends the workbook by using the PowerTalk mailer. This method is available only on the Macintosh, with the PowerTalk system extension installed, and it can only be used on a workbook that has a mailer attached.

Syntax

expression.SendMailer(FileFormat, Priority)

expression Required. An expression that returns a Workbook object.

FileFormat Optional Variant. Specifies the file format to use for the workbook that's sent. See the FileFormat property for a list of valid types.

Priority Optional Variant. Specifies the delivery priority of the message. Can be one of the following XlPriority constants: xlPriorityNormal, xlPriorityHigh, or xlPriorityLow. The default value is xlPriorityNormal.

Remarks

Use the SendMail method in Microsoft Mail (MAPI or Microsoft Mail for the Macintosh) e-mail systems. Pass addressing information as parameters.

Use the SendMailer method in PowerTalk e-mail systems on the Macintosh. The Mailer object contains the addressing information for PowerTalk.

See Also

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