Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
60 lines (38 sloc) 2.27 KB
title keywords f1_keywords ms.prod api_name ms.assetid ms.date localization_priority
Workbook.SendForReview method (Excel)
vbaxl10.chm199206
vbaxl10.chm199206
excel
Excel.Workbook.SendForReview
3834f5b3-6d24-1bb9-27b5-052aa2e725e3
05/29/2019
Normal

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 will 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

[!includeSupport and feedback]

You can’t perform that action at this time.