Reply 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 the originator 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.Reply

expression Required. An expression that returns a Workbook object.

Remarks

To reply to 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, ReplyAll method, SendMailer method.

Example

This example replies to the sender of the active workbook.

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