WorkbookBase.SendMail(Object, Object, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Sends the workbook by using the installed mail system.
public void SendMail (object recipients, object subject, object returnReceipt);
member this.SendMail : obj * obj * obj -> unit
Public Sub SendMail (recipients As Object, Optional subject As Object, Optional returnReceipt As Object)
Parameters
- recipients
- Object
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
- Object
Specifies the subject of the message. If this argument is omitted, the document name is used.
- returnReceipt
- Object
true
to request a return receipt. false
to not request a return receipt. The default value is false
.
Examples
The following code example uses the SendMail method to send the workbook in an e-mail to a single recipient. The e-mail will have the subject "Please review" and will not request a return receipt.
This example is for a document-level customization.
private void WorkbookSendMail()
{
this.SendMail("someone@example.com", "Please review this proposal.", false);
}
Private Sub WorkbookSendMail()
Me.SendMail("someone@example.com", "Please review", False)
End Sub
Remarks
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.