How to FAX from VB6 and Access 2000

[microdoc]

OK, here goes. I have a query set up in my access database with all the customers who wish to receive our fax data. What I need to do is design a program that will use this query to send the fax with/or without a cover page automatically. I have Winfax PRO available or windows faxing (win98SE machine). If necessary, I can upgrade the systems to 2000 or XP.

Other things I would like to do is to be able to stop the process at any time and resume, maybe even select a range of numbers (from record # 1 - 1000, 1001 - 2000, etc). If you have any other ideas as to what might be good for this, please feel free to elaborate.

Let me state this....THIS IS NOT FOR SPAMMING....it is a legitimate list of our customers who wish to receive our faxed flyer....not a random list or random numbers.

I am not a programmer, but I can do some basic programming in VB, and all i've received back on this from people (NOT here) is "it's SO easy"....but I need a WORKING example...that I can tweak if necessary.

Can anyone out there help me? copy here and to email would be great. microdoc@yahoo.com

 

[CCLINT]

Set up a printer fax driver in windows.
Then, just change to this printer in VB using the Printers collection and use the Printer Object.

 

[microdoc]

I would like this to be an AUTOMATED process....Tell it where to start, where to end, and then Stepping through the records one at a time.

Any possibility of getting an example?

 

[CCLINT]

er, use a data report which gets it's data from a recordset, or save the results to a text file, and then sent the print to the fax printer.
You would need create a VB Data form to navigate and filter the records you want to show, and in the DataReport click the pages you want to send/print.

If you are not a programer, but are looking for a simple method to do this, such as through a RAD tool, then I suggest you do the with a MS Office product, such as MS ACCESS. There, it would be much easier for you to accomplish this task.
There are also other VB sites where people may write the working code for you - I just cannot remember the URL - but it was mentioned here a few times back. Check the TT LINKS here at the top.