WorkbookBase.SendFaxOverInternet(Object, Object, Object) Method

Definition

Namespace:

Microsoft.Office.Tools.Excel

Assembly:

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

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.