SendMail Method

Applies To

Workbook Object.

Description

Sends the workbook using the installed mail system.

Syntax

object.SendMail(recipients, subject, returnReceipt)

object

Required. The Workbook object.

recipients

Required. Specifies the name of the recipient as text, or 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. Specifies the subject of the message. If omitted, the document name is used.

returnReceipt

Optional. If True, a return receipt is requested. If False or omitted, no return receipt is requested.

Remarks

Use the SendMail method on Microsoft Mail (MAPI or Microsoft Mail for the Apple Macintosh) email systems. Pass addressing information as parameters.

See Also

Mailer Object, MailSystem Property, SendMailer Method.

Example

This example sends the active workbook to a single recipient.


ActiveWorkbook.SendMail recipients:="Jean Selva"

Use the SendMailer method on PowerTalk email systems on the Apple Macintosh. The Mailer object contains the addressing information for PowerTalk.