WorkbookBase.SendFaxOverInternet(Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Sends the active sheet in the workbook as a fax to the specified recipients.

public void SendFaxOverInternet (object recipients, object subject, object showMessage);

member this.SendFaxOverInternet : obj * obj * obj -> unit

Public Sub SendFaxOverInternet (Optional recipients As Object, Optional subject As Object, Optional showMessage As Object)

Parameters

recipients: Object

The fax numbers and e-mail addresses of the people to whom the fax will be sent. Separate multiple recipients with a semicolon.

subject: Object

The subject line for the faxed document.

showMessage: Object

true displays the fax message before sending it; false sends the fax without displaying the fax message.

Examples

The following code example uses the SendFaxOverInternet method to send the current workbook as a fax and display the fax message before sending it.

This example is for a document-level customization.

private void WorkbookSendFaxOverInternet()
{
    // First add a range value to make sure that the workbook
    // is faxed. An empty workbook will not be faxed.
    Globals.Sheet1.Range["A1", "A5"].Value2 = 55;
    this.SendFaxOverInternet("ContosoSales@15555550101",
        "For your review.", true);
}

Private Sub WorkbookSendFaxOverInternet()
    ' First add a range value to make sure that the workbook
    ' is faxed. An empty workbook will not be faxed.
    Globals.Sheet1.Range("A1", "A5").Value2 = 55
    Me.SendFaxOverInternet( _
        "ContosoSales@15555550101", _
        "For your review.", True)
End Sub

Remarks

Using this method requires that the fax service is enabled on a user's computer.

The format used for specifying fax numbers in the Recipients parameter is either recipientsfaxnumber@usersfaxprovider or recipientsname@recipientsfaxnumber. You can access the user's fax provider information using the following registry path:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Services\Fax

Use the value of the FaxAddress key at this registry path to determine the format to use for a recipient.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to