Workbook.SendMail Method (Excel)

Sends the workbook by using the installed mail system.

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.

This example sends the active workbook to a single recipient.

ActiveWorkbook.SendMail recipients:="Jean Selva"
Show:
© 2014 Microsoft