This documentation is archived and is not being maintained.

Workbook.SendForReview Method

Office 2007
Sends a workbook in an e-mail message for review to the specified recipients.


expression.SendForReview(Recipients, Subject, ShowMessage, IncludeAttachment)

expression   A variable that represents a Workbook object.


NameRequired/OptionalData TypeDescription
RecipientsOptionalVariantA string that lists the people to whom to send the message. These can be unresolved names and aliases in an e-mail phone book or full e-mail addresses. Separate multiple recipients with a semicolon (;). If left blank and ShowMessage is False, you will receive an error message, and the message will not be sent.
SubjectOptionalVariantA string for the subject of the message. If left blank, the subject will be: Please review "filename".
ShowMessageOptionalVariantA Boolean value that indicates whether the message should be displayed when the method is executed. The default value is True. If set to False, the message is automatically sent to the recipients without first showing the message to the sender.
IncludeAttachmentOptionalVariantA Boolean value that indicates whether the message should include an attachment or a link to a server location. The default value is True. If set to False, the document must be stored at a shared location.


The SendForReview method starts a collaborative review cycle. Use the EndReview method to end a review cycle.


This example automatically sends the active workbook as an attachment in an e-mail message to the specified recipients.

Visual Basic for Applications
Sub WebReview()

    ActiveWorkbook.SendForReview _
        Recipients:="; amy jones; lewjudy", _
        Subject:="Please review this document.", _
        ShowMessage:=False, _

End Sub