SendMail Method
This documentation is archived and is not being maintained.

Workbook.SendMail Method

Office 2007
Sends the workbook by using the installed mail system.

Syntax

expression.SendMail(Recipients, Subject, ReturnReceipt)

expression   A variable that represents a Workbook object.

Parameters

NameRequired/OptionalData TypeDescription
RecipientsRequiredVariantSpecifies 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.
SubjectOptionalVariantSpecifies the subject of the message. If this argument is omitted, the document name is used.
ReturnReceiptOptionalVariantTrue 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.

Visual Basic for Applications
ActiveWorkbook.SendMail recipients:="Jean Selva"



Show:
© 2016 Microsoft