ReplyAll Method

Applies To

Workbook object.

Description

Replies to the workbook by creating a copy of the workbook and pre-initializing the new workbook's mailer to send to all recipients of the workbook. Valid only when the workbook has a received mailer attached (you can only reply to a workbook you've received). Available only in Microsoft Excel for the Macintosh, with the PowerTalk mail system extension installed.

Syntax

expression.ReplyAll

expression Required. An expression that returns a Workbook object.

Remarks

To reply to all recipients of a workbook, use this method to set up the mailer, use the Mailer property to adjust the mailer settings (if necessary), and then use the SendMailer method to send the reply.

This method generates an error if it's used in Windows.

See Also

Mailer property, MailSystem property, Reply method, SendMailer method.

Example

This example replies to all recipients of the active workbook.

Set original = ActiveWorkbook
If original.HasMailer Then
    original.ReplyAll
    original.Mailer.Subject = "Here's my reply"
    ActiveWorkbook.SendMailer
End If