Workbook.SendFaxOverInternet Method
Sends a worksheet as a fax to the specfied 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 e-mail 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 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.
Example
The following example sends a fax to the fax service provider, which will then fax the message to the recipient.
| Visual Basic for Applications |
|---|
|