Workbook.SendFaxOverInternet method (Excel)

Sends a worksheet as a fax to the specified recipients.

Syntax

expression.SendFaxOverInternet (Recipients, Subject, ShowMessage)

expression A variable that represents a Workbook object.

Parameters

Name	Required/Optional	Data type	Description
Recipients	Optional	Variant	A String that represents the fax numbers and email addresses of the people to whom the fax will be sent. Separate multiple recipients with a semicolon.
Subject	Optional	Variant	A String that represents the subject line for the faxed document.
ShowMessage	Optional	Variant	True displays the fax message before sending it. False sends the fax without displaying the fax message.

Remarks

Using the SendFaxOverInternet 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 by using the following registry path:

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

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

Example

The following example sends a fax to the fax service provider, which then faxes the message to the recipient.

ActiveWorkbook.SendFaxOverInternet _ 
 "14255550101@consolidatedmessenger.com", _ 
 "For your review", True

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.