This is actually not an ms access question , for all to be done client side is to print a report to a shared virtual fax driver over the 2003 server.
How to setup one is beyond this forum scope , please consult your mail merge like application manuals
Hmm...
Perhaps I misunderstand - or perhaps I have been too short in posing my question.
There is a FaxDocument object that comes with the Fax Services bundled in XP, Windows 2003 Server and Vista.
One could use a piece of code such as the following to send a test document.
Dim FS As New FAXCOMEXLib.FaxServer
Dim FD As New FAXCOMEXLib.FaxDocument
FS.Connect "MyServer"
FD.Body = "C:\Temp\test.rtf"
FD.CoverPageType = fcptNONE
FD.DocumentName = "Test"
FD.Priority = fptHIGH
FD.Recipients.Add (faxNumber)
FD.Submit("MyServer")
I am asking if anybody has had any experience with using this method to effectively distribute a series of reports based on a query of a table to a list of recipients drawn from such table.
The effect would be very similar to a "Mail Merge" using something like MS Word, but it would be completely generated from within Access 2007.
The user would simply initiate the process by clicking on a button, after which a batch of faxes would be lined up in the fax queue and delivered to recipients.
So, with that in mind... the 2 parts of the question I asked were:
- How do I output a report from Access 2007 directly to a Fax Server residing on Windows 2003 server?
- Please bear in mind that I do not want Outlook installed on the client machines , so the solution needs to be within VBA only.
Does this then sound like it is an Access question now?
What I am looking for is not simply a piece of code, that is what Google is there for. I would like to have a conversation with some of the people who have already walked down that path so that I can learn from their experience and avoid the pitfalls.
