Partager via


WorkbookBase.SendFaxOverInternet Method

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

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

Syntax

'Declaration
Public Sub SendFaxOverInternet ( _
    recipients As Object, _
    subject As Object, _
    showMessage As Object _
)
public void SendFaxOverInternet(
    Object recipients,
    Object subject,
    Object showMessage
)

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

WorkbookBase Class

Microsoft.Office.Tools.Excel Namespace