Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

Workbook.SendMail Method

Sends the workbook by using the installed mail system.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

'Declaration
Public Overridable Sub SendMail ( _
	Recipients As Object, _
	<OptionalAttribute> Subject As Object, _
	<OptionalAttribute> ReturnReceipt As Object _
)

Parameters

Recipients

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

Specifies the subject of the message. If this argument is omitted, the document name is used.

ReturnReceipt

true to request a return receipt. false to not request a return receipt. The default value is false.

Optional Parameters

For information on optional parameters, see Understanding Optional Parameters in COM Interop.

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.

Private Sub WorkbookSendMail()
    Me.SendMail("someone@example.com", "Please review", False)
End Sub

Show:
© 2015 Microsoft