Faxing in Access 1

[romh]

Okay, I know how to email something from VBA in access, but how I would how would I go about sending a fax?
I have Winfax software. Is there a way to use this software, or can I simply send a fax from VBA through the fax/modem.

Thankyou very much

I have an Access 2000 database running on a Windows 2000 Adv server AD and Windows 98/2000 professional clients

 

[pelida]

Bad News, WinFax Doesn't like Windows 2000 Server. It is on Symantec Web Page. I'm looking for an alternate solution, if you find one let me Know

 

[McFestoe]

romh,

I have the same setup, i know this is a simple way but it works for us, we only have to fax single page rports so when the report is run it shows on the screen then right click select print, change printer to winfax hit ok then it brings up winfax header page and stuff.

Its probally not what you want, but i have been working on sending via winfax for abit and not found away to automate it yet.

McFestoe

 

[romh]

mcfestoe and pelida:
That would work fine for one report. What i really need is a way to fax multiple reports at a certain time eveyday. I figured out how to fax one report through the winfax sdk and vba without a problem. But sometimes I need to fax 1 report to one fax, then immediately another one to another fax, and maybe another one etc.... That's when winfax doesn;t perform as expected. I wrote some code in vba using the winfax sdk in a loop, but it sends the first fax correctly, and not the second, or third, or fourth ......

Thanks

 

[cranebill]

Hi,
There is another solution to this. I found an FAQ on the Microsoft web site that covers this topic. Here is the link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;231851

If you scroll down, you will see a file that can be downloaded that contains various report samples, including one that shows how to use WinFax. The file is called:
RptSmp00.exe

Now, you will find two separate functions for WinFax inside the Modules window. Look for the module called "modFaxExample", then click on Design. Scroll down until you see the function called "WinFaxInvoices". Also take a look at the function "SendWinFax".

This has worked in 2k and 98 for me but cannot get it to work in XP.

HTH
Bill

 

[romh]

That;'s a really good example. Just downloaded it. I would have never found that. I'll try sending multiple faxes and let you know how it went. Thanks alot

 

[cranebill]

Glad to help Keep me posted.

Bill

 

[Trudye]

Hi Cranebill, I saw your response to romh. I went to the site you mentioned but did not find any reference to faxing.
The file has probably been updated. Could you pass along/publish the instructions?

Thank you,
Trudye

 

[PabloGeek]

Hi Trudye, came across the original post. Updated website is

http://www.microsoft.com/downloads/...a5-c76f-4eda-bc9a-5fac336ef7f1&displayLang=en

The file name to downlaod is RptSampl.exe, hope it helps.