Programming Excel with VBA and .NET

Name

workbook.SendForReview([Recipients], [Subject], [ShowMessage], [IncludeAttachment])

Synopsis

Sends a workbook via email, beginning the review process. In order to track reviewers’ comments, the workbook must be shared.

Argument	Settings
Recipients	The email names or aliases of the reviewers.
Subject	A subject line to include with the email.
ShowMessage	True displays the email message before sending; False does not. Default is True.
IncludeAttachment	True includes the workbook as a file attachment; False includes a link to the workbook (file must be saved at a network address). Default is True.

The following code sends a workbook for review, previewing the message before sending. If the workbook is not already shared, Excel displays a prompt asking if you would like to save it as a shared workbook before sending:

ThisWorkbook.SendForReview "[e-mail]", "Workbook samples"

Use the EndReview method to end the review process.