SendFaxOverInternet Method
This documentation is archived and is not being maintained.

Workbook.SendFaxOverInternet Method

Office 2007
Sends a worksheet as a fax to the specfied recipients.


expression.SendFaxOverInternet(Recipients, Subject, ShowMessage)

expression   A variable that represents a Workbook object.


NameRequired/OptionalData TypeDescription
RecipientsOptionalVariantA 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.
SubjectOptionalVariantA String that represents the subject line for the faxed document.
ShowMessageOptionalVariantTrue displays the fax message before sending it. False sends the fax without displaying the fax message.


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.


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

Visual Basic for Applications
ActiveWorkbook.SendFaxOverInternet _
    "", _
    "For your review", True

© 2016 Microsoft