A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Fax
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

MS Fax and MS ACCESS REPORTS



 
 
Thread Tools Display Modes
  #1  
Old March 10th, 2005, 10:30 PM
Nour
external usenet poster
 
Posts: n/a
Default MS Fax and MS ACCESS REPORTS

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



  #2  
Old March 10th, 2005, 10:58 PM
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: n/a
Default

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" wrote in message
. ..
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





  #3  
Old March 11th, 2005, 12:25 AM
Nour
external usenet poster
 
Posts: n/a
Default

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]" a écrit dans le message de
news: ...
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" wrote in message
. ..
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







  #4  
Old March 11th, 2005, 01:53 AM
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: n/a
Default

Reply to the rest of my questions.
--
Russ Valentine
[MVP-Outlook]
"Nour" wrote in message
. ..
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]" a écrit dans le message
de
news: ...
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" wrote in message
. ..
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









  #5  
Old March 11th, 2005, 02:15 AM
Nour
external usenet poster
 
Posts: n/a
Default


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





  #6  
Old March 11th, 2005, 02:54 AM
Nour
external usenet poster
 
Posts: n/a
Default

Hi,

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

Thank you for you help.

Nour


"Nour" a écrit dans le message de news:
...
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





  #7  
Old March 11th, 2005, 09:59 AM
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: n/a
Default

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

--
Russ Valentine
[MVP-Outlook]
"Nour" wrote in message
...
Hi,

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

Thank you for you help.

Nour


"Nour" a écrit dans le message de news:
...
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







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.