Workbook.SendFaxOverInternet Method (Excel)
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\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 will then fax the message to the recipient.
ActiveWorkbook.SendFaxOverInternet _
"14255550101@consolidatedmessenger.com", _
"For your review", True