SEND.MAIL

Macro Sheets Only

Equivalent to choosing the Send Mail command from the File menu. Sends the active workbook using email.

Syntax

SEND.MAIL(recipients, subject, return_receipt)
SEND.MAIL?(recipients, subject, return_receipt)

Important To use SEND.MAIL in Microsoft Excel for Windows, you must be using a mail client that supports the Messaging Applications Programming Interface (MAPI) or Vendor-Independent Messaging (VIM). To use SEND.MAIL in Microsoft Excel for the Macintosh, you must be using Microsoft Mail version 2.0 or later.

Recipients is the name of the person to whom you want to send the mail. The name should be given as text.

Subject is a text string that specifies the subject of the message. If subject is omitted, the name of the active workbook is used as the subject.

Return_receipt is a logical value that corresponds to the Return Receipt check box. If return_receipt is TRUE, Microsoft Excel selects the check box and sends a return receipt; if FALSE or omitted, Microsoft Excel clears the check box.

Related Function

OPEN.MAIL Opens files sent via Microsoft Mail that Microsoft Excel can open

List of Command-Equivalent Functions