Workbook.SendFaxOverInternet Method (2007 System)

  • Article

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

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
Public Sub SendFaxOverInternet ( _
    Recipients As Object, _
    Subject As Object, _
    ShowMessage As Object _
)

'Usage
Dim instance As Workbook 
Dim Recipients As Object 
Dim Subject As Object 
Dim ShowMessage As Object

instance.SendFaxOverInternet(Recipients, _
    Subject, ShowMessage)

public void SendFaxOverInternet(
    Object Recipients,
    Object Subject,
    Object ShowMessage
)

public:
void SendFaxOverInternet(
    Object^ Recipients, 
    Object^ Subject, 
    Object^ ShowMessage
)

public function SendFaxOverInternet(
    Recipients : Object, 
    Subject : Object, 
    ShowMessage : Object
)

Parameters

  • Recipients
    Type: System.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
    Type: System.Object

    The subject line for the faxed document.

  • ShowMessage
    Type: System.Object

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

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 The Variable missing and Optional Parameters in Office Solutions.

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 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

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);
}

.NET Framework Security

See Also

Reference

Workbook Class

Workbook Members

Microsoft.Office.Tools.Excel Namespace