Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2005
Visual Studio
Visual Studio Tools for Office
Reference
Microsoft.Office.Tools.Excel
Workbook Class
Workbook Methods
_PrintOut Method
_Protect Method
_SaveAs Method
AcceptAllChanges Method
Activate Method
AddToFavorites Method
BeginInit Method
BreakLink Method
CanCheckIn Method
ChangeFileAccess Method
ChangeLink Method
CheckIn Method
Close Method
DeleteNumberFormat Method
Dispose Method
Dummy16 Method
Dummy17 Method
EndInit Method
EndReview Method
ExclusiveAccess Method
FollowHyperlink Method
ForwardMailer Method
get_Colors Method
GetObjects Method
GetPrimaryControl Method
HighlightChangesOptions Method
LinkInfo Method
LinkSources Method
MergeWorkbook Method
Microsoft.VisualStudio.Tools.Applications.Runtime.IActivatable.OnNew Method
Microsoft.VisualStudio.Tools.Applications.Runtime.IActivatable.OnOpen Method
Microsoft.VisualStudio.Tools.Applications.Runtime.ISupportInitializeControl.InitializeControl Method
NewWindow Method
OnShutdown Method
OnStartup Method
OpenLinks Method
PivotCaches Method
PivotTableWizard Method
Post Method
PrintOut Method
PrintPreview Method
Protect Method
ProtectSharing Method
PurgeChangeHistoryNow Method
RecheckSmartTags Method
RefreshAll Method
RejectAllChanges Method
ReloadAs Method
RemoveCustomization Method
RemoveUser Method
Reply Method
ReplyAll Method
ReplyWithChanges Method
ResetColors Method
Route Method
RunAutoMacros Method
Save Method
SaveAs Method
SaveAsXMLData Method
SaveCopyAs Method
sblt Method
SendFaxOverInternet Method
SendForReview Method
SendMail Method
SendMailer Method
set_Colors Method
SetLinkOnData Method
SetPasswordEncryptionOptions Method
ToggleFormsDesign Method
Unprotect Method
UnprotectSharing Method
UpdateFromFile Method
UpdateLink Method
WebPagePreview Method
XmlImport Method
XmlImportXml Method
Expand Minimize
1 out of 15 rated this helpful - Rate this topic

Workbook.SendMail Method

Visual Studio 2005

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)

C#
VB
Copy 
'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.

C#
VB
Copy 
Private Sub WorkbookSendMail()
    Me.SendMail("someone@example.com", "Please review", False)
End Sub
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.