Workbook.SendMail method (Excel)
Sends the workbook by using the installed mail system.
Syntax
expression.SendMail (Recipients, Subject, ReturnReceipt)
expression A variable that represents a Workbook object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Recipients | Required | Variant | Specifies the name of the recipient as text, or as an array of text strings if there are multiple recipients. At least one recipient must be specified, and all recipients are added as To recipients. |
| Subject | Optional | Variant | Specifies the subject of the message. If this argument is omitted, the document name is used. |
| ReturnReceipt | Optional | Variant | True to request a return receipt. False to not request a return receipt. The default value is False. |
Example
This example sends the active workbook to a single recipient.
ActiveWorkbook.SendMail recipients:="Jean Selva"
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.