A Challenging And Interesting Question

[buddylove69]

hi!

I am currently working with an Access database. In my work place we just baught a new server called RightFax. It's a fax server which allows the employees sending faxes from their computer (No need for fax machines or paper anymore ). I was asked by my supervisor to try and build a code which consists of making automatic faxing without any human intervention. To be more precise, we have in our database an invoice table, and what we want to do is to automatically send faxes of invoices that are 30 days past due. How do I tell the rightfax to pull out all these information from the database? How do I send it automatically?

Pretty Challenging hah?

[Hack]

I have no idea how you would sent it automatically. My question would be, how do you send it manually? Once this question was answered, automating the manual process shouldn't be difficult (he said with a wary smile).

As far as pulling invoice data, it would seem as simple as an SQL query based on date, and whatever else you require to build an invoice, that creates a recordset, and then feed the recordset into your fax process. Each day that goes day that goes by tickes off another day on the calendar, so you could have something in your Form_Load that scans the Db each time it is open for all stuff that fit within a time parameter.

[buddylove69]

Well the way we send a fax is like this:

We pull out an invoice from the database. Then we go to Print and we choose the printer that we want. But in this case we choose the RightFax. Once we chose that option, there is a window that pops up where we put the name of the person and the fax number to where we will send the invoice (we can also attach different files if we want to). The client's fax number is also in the invoice (which is pulled from the Database).

I want this process to be automatic. Without any human intervention.

I spoke to many representative from the RightFax Company and they haven't had the clue on how to do it (beleive it or not).

So I need your help instead.
I would greatly appreciate it.

[Hack]

Then we go to Print and we choose the printer that we want. But in this case we choose the RightFax.

This is easy to programmatically select (although the code for is a mile and a half long.)

there is a window that pops up where we put the name of the person and the fax number to where we will send the invoice

What generates this window? Is it the RightFax software?

[buddylove69]

Hi Again!

First, I want to thank you for your time, and I hope that this problem or question will be solved . Yes it is the RightFax that makes this particular window pop up.

[Hack]

Ok, so its a RightFax Window. After you type in your stuff, what happens. Do you click an OK button?

[buddylove69]

Once I entered all the necessary information, I click on "Send". The RightFax reads the documents and then sends it. In some cases the RightFax is converting the document in a way so it can read it (usually happends when you want to send pictures, graphs, or any other image).