Workbook.SendForReview method (Excel)
Sends a workbook in an email message for review to the specified recipients.
Syntax
expression.SendForReview (Recipients, Subject, ShowMessage, IncludeAttachment)
expression A variable that represents a Workbook object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Recipients | Optional | Variant | A string that lists the people to whom to send the message. These can be unresolved names and aliases in an email phone book or full email addresses. Separate multiple recipients with a semicolon (;). If left blank and ShowMessage is False, you'll receive an error message, and the message will not be sent. |
| Subject | Optional | Variant | A string for the subject of the message. If left blank, the subject will be: Please review "filename". |
| ShowMessage | Optional | Variant | A 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. |
| IncludeAttachment | Optional | Variant | A 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. |
Remarks
The SendForReview method starts a collaborative review cycle. Use the EndReview method to end a review cycle.
Example
This example automatically sends the active workbook as an attachment in an email message to the specified recipients.
Sub WebReview()
ActiveWorkbook.SendForReview _
Recipients:="someone@example.com; amy jones; lewjudy", _
Subject:="Please review this document.", _
ShowMessage:=False, _
IncludeAttachment:=True
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.