Workbook.SendMail (Excel)

Sends the workbook by using the installed mail system.

SendMail (Recipients, Subject, ReturnReceipt)

ActiveWorkbook.SendMail recipients:="Jean Selva"

Arguments

The following argument is required

Recipients (String) - 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.

Optional arguments

The following arguments are optional

Subject (String) - Specifies the subject of the message. If this argument is omitted, the document name is used.

ReturnReceipt (Boolean) - True to request a return receipt. False to not request a return receipt. The default value is False.