Fax MS Access report

[Rasik]

Hello

I do have a MS Access report and field like Customer name, order id and fax.
When I will open report, I would like to send report to all customer by
fax(fax# listed in report). Please infomr me how to do this one.

Thanks

R Mehta

 

[Rick B]

Are you using fax driver software? I'm not sure I understand your question.
There is no built in fax capabilities in Microsoft Access.

Rick B


Hello

I do have a MS Access report and field like Customer name, order id and fax.
When I will open report, I would like to send report to all customer by
fax(fax# listed in report). Please infomr me how to do this one.

Thanks

R Mehta

 

[Rasik]

Yes, I am using MS Windows XP and it has Fax.

DoCmd.SendObject acSendReport, "report_fax", acFormatRTF, "[fax:" & [fax]
&"]"

I do get some error [fax] field.

Please let me know if you need more info.

Thanks

 

[Guest]

Sorry this is no help but I am having a similar issue with the same code.
Also noticed later the code was for access97 and am using 2003 but when it
does do a send it actually places it in the outbox of outlook 2003 but it is
only an attachment in RTF format. I was hoping it would simply send it to the
fax printer driver using the phone number provided.
I believe your problem is probably because your fax phone number field is
not [fax] as in the code because mine actually did get the number from it.
But when it did the send just placed it in Outlook 2003 outbox and never sent
it and even then did it as a message attachment. So once you get your send
going you may experience same.

Yes, I am using MS Windows XP and it has Fax.

DoCmd.SendObject acSendReport, "report_fax", acFormatRTF, "[fax:" & [fax]
&"]"

I do get some error [fax] field.

Please let me know if you need more info.

Thanks

Are you using fax driver software? I'm not sure I understand your question.
There is no built in fax capabilities in Microsoft Access.

Rick B


Hello

I do have a MS Access report and field like Customer name, order id and fax.
When I will open report, I would like to send report to all customer by
fax(fax# listed in report). Please infomr me how to do this one.

Thanks

R Mehta

 

[SA]

Dave:

1.) Have you added the Fax Mail transport to Outlook? Tools-> Email
Accounts -> Add A New Account -> Other Server Types?

2.) Is the fax server service configured to be loaded and automatically
started in the services control panel?


You can also control the Win 2000 and WinXp Fax services with code like that
noted below, however note that you first have to output the Report to either
a snapshot (preferable) or to a RTF file and then supply that file as the
output file.:
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


Public Function Win2KFax(strFaxDocument as String)
'Works on Xp as well
Dim objFaxServer As Object
Dim objFax As Object
Dim dwReturn&, lngJobID As Long
Dim strDocFile As String
Set objFaxServer = CreateObject("FaxServer.FaxServer")
dwReturn = objFaxServer.Connect(vbNullString) 'local fax server
'objFaxServer.PauseServerQue True 'To hold the fax
Set objFax = objFaxServer.CreateDocument(strFaxDocument)
With objFax
.FaxNumber = "18005551212"
End With
lngJobID = objFax.Send
objFaxServer.Disconnect
Set objFaxServer = Nothing
End Function

Sorry this is no help but I am having a similar issue with the same code.
Also noticed later the code was for access97 and am using 2003 but when it
does do a send it actually places it in the outbox of outlook 2003 but it
is
only an attachment in RTF format. I was hoping it would simply send it to
the
fax printer driver using the phone number provided.
I believe your problem is probably because your fax phone number field is
not [fax] as in the code because mine actually did get the number from it.
But when it did the send just placed it in Outlook 2003 outbox and never
sent
it and even then did it as a message attachment. So once you get your send
going you may experience same.

Yes, I am using MS Windows XP and it has Fax.

DoCmd.SendObject acSendReport, "report_fax", acFormatRTF, "[fax:" & [fax]
&"]"

I do get some error [fax] field.

Please let me know if you need more info.

Thanks

Are you using fax driver software? I'm not sure I understand your question.
There is no built in fax capabilities in Microsoft Access.

Rick B


Hello

I do have a MS Access report and field like Customer name, order id and fax.
When I will open report, I would like to send report to all customer
by
fax(fax# listed in report). Please infomr me how to do this one.

Thanks

R Mehta