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 |
|---|---|
|
|
The email names or aliases of the reviewers. |
|
|
A subject line to include with the email. |
|
|
True displays the email message before sending; False does not. Default is True. |
|
|
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 "ExcelDemo@Hotmail.com", "Workbook samples"
Use the EndReview method to end the review process.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access