MS Fax and MS ACCESS REPORTS

[Nour]

Hi,

I am trying to fax (using ms fax) an access report.
The report is faxed but only text appear on the fax and all
formatting/images are missing.
It seems that word rendering is not working properly.
Does anyone know how to fix that.

Thanks,

Nour

 

[Russ Valentine [MVP-Outlook]]

You've provided none of the necessary information.
ms fax? What's that? Provide your fax software.
List the precise steps by which you are sending the fax and how this is
related to Outlook.

 

[Nour]

Hi,

Here is the code ...

' Fax report ...
DoCmd.SendObject acReport, stDocName, acFormatRTF, "[fax: " & strTel &
"]", , , , , False


Note:
- I have win XP home edition.
- I have installed Microsoft FAX service.
- In Outlook, I added "Fax tansport protocol"
- My report ( stDocName ) contains both textes and images.
- When I hit "Send Fax" button, an email is sent to outlook.
- Then I have to go to outlook and click on "send & receive" which triggers
the "rendering process" using ms word. Otherwise I have to wait until
outlook does the automated send and receive, in my case every minute
(another problem I have to solve ) .

Nour

You've provided none of the necessary information.
ms fax? What's that? Provide your fax software.
List the precise steps by which you are sending the fax and how this is
related to Outlook.
--
Russ Valentine
[MVP-Outlook]

Hi,

I am trying to fax (using ms fax) an access report.
The report is faxed but only text appear on the fax and all
formatting/images are missing.
It seems that word rendering is not working properly.
Does anyone know how to fix that.

Thanks,

Nour

 

[Russ Valentine [MVP-Outlook]]

Reply to the rest of my questions.
--
Russ Valentine
[MVP-Outlook]

Hi,

Here is the code ...

' Fax report ...
DoCmd.SendObject acReport, stDocName, acFormatRTF, "[fax: " & strTel &
"]", , , , , False


Note:
- I have win XP home edition.
- I have installed Microsoft FAX service.
- In Outlook, I added "Fax tansport protocol"
- My report ( stDocName ) contains both textes and images.
- When I hit "Send Fax" button, an email is sent to outlook.
- Then I have to go to outlook and click on "send & receive" which
triggers
the "rendering process" using ms word. Otherwise I have to wait until
outlook does the automated send and receive, in my case every minute
(another problem I have to solve ) .

Nour

"Russ Valentine [MVP-Outlook]" <[email protected]> a écrit dans le message
de

You've provided none of the necessary information.
ms fax? What's that? Provide your fax software.
List the precise steps by which you are sending the fax and how this is
related to Outlook.
--
Russ Valentine
[MVP-Outlook]

Hi,

I am trying to fax (using ms fax) an access report.
The report is faxed but only text appear on the fax and all
formatting/images are missing.
It seems that word rendering is not working properly.
Does anyone know how to fix that.

Thanks,

Nour

 

[Nour]

the code i run in ACCESS 2002 is ...


Private Sub cmdSendFax_Click()

On Error GoTo Err_cmdFax_Click

Dim stDocName As String
Dim strFileAndPath As String
Dim strTel As String

' in case data was changed, save before faxing ..
Call cmdSave_Click

' Select language
'strLang= "Fr"

Dim nInput As Variant
Do
nInput = InputBox("English Fax ( 1 ), French Fax ( 2 ) ", "Fax
Language", 1)
Loop Until nInput = 1 Or nInput = 2

strLang = Choose(nInput, "En", "Fr")

strTel = Form_Entreprise.Fax '."5142730120" ' "5142701212"
stDocName = "FaxDoc"

' Fax report ...
DoCmd.SendObject acReport, stDocName, acFormatRTF, "[fax: " & strTel &
"]", , , , , False ' Runs Report to MSFax ' acFormatRTF
SendReceiveNow


Exit_cmdFax_Click:
Exit Sub

Err_cmdFax_Click:
MsgBox Err.Description
Resume Exit_cmdFax_Click

End Sub

 

[Nour]

Hi,

Never mind I found a solution.
I just changed acFormatRTF to acFormatSNP in the << Docmd.SendObject >>
call.

Thank you for you help.

Nour

 

[Russ Valentine [MVP-Outlook]]

Aha. Did your document have any elements that would require rendering?

 

[Nour]

Yes, images and special formatting. I already mentioned that in my first
post.

Thanks.
Nour

Aha. Did your document have any elements that would require rendering?

--
Russ Valentine
[MVP-Outlook]

Hi,

Never mind I found a solution.
I just changed acFormatRTF to acFormatSNP in the << Docmd.SendObject >>
call.

Thank you for you help.

Nour