MS Fax and MS ACCESS REPORTS

  • Thread starter Thread starter Nour
  • Start date Start date
N

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
 
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.
 
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 said:
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]
Nour said:
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
Click to expand...
Click to expand...
 
Reply to the rest of my questions.
--
Russ Valentine
[MVP-Outlook]
Nour said:
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]
Nour said:
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
Click to expand...
Click to expand...
Click to expand...
 
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
 
Hi,

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

Thank you for you help.

Nour
 
Aha. Did your document have any elements that would require rendering?
 
Yes, images and special formatting. I already mentioned that in my first
post.

Thanks.
Nour

Russ Valentine said:
Aha. Did your document have any elements that would require rendering?

--
Russ Valentine
[MVP-Outlook]
Nour said:
Hi,

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

Thank you for you help.

Nour
Click to expand...
Click to expand...
 
Back
Top