Fax from Excel with VB - any takers out there?

[iphorum]

I’ve been working on a specialized quote and order workbook and with the generous help of you guys have gotten almost all of it done. The remaining challenge is how to fax from Excel. SteveF (bless his heart) saved all of us a huge amount of work by posting his excellent How To on PDF to Excel using PDF995 pdf print driver at this address:
http://www.mrexcel.com/board2/viewtopic.php?t=119332&highlight=excel+pdf


I incorporated his stuff, and a lot of other help from this forum, to define and print as pdf and send the resulting worksheet.pdf as an email attachment with the click of the mouse on the macro button, passing the email address, etc., looked up in the database.

What I am wondering is has anyone done something similar only with faxing? I have searched everywhere, and I have come to the conclusion that it is either so easy that its not worth mentioning, or everyone just uses the standard fax software and lets it go at that.

What I want to do is pass the fax number, recipient, subject, etc., to a fax printer driver (like the PDF995 pdf driver) to create and send the fax from a worksheet (my quote module).

I did find a little info at http://www.sunny-beach.net/manual/347.htm#o347 on this but am not, as yet, gifted enough with VB to know where to start with it. The sunny-beach folks have a product called Active Call Center that costs about $300 and does way more than I need it to do. I would really appreciate it if any of you gurus have a handle on this or know if someone has worked with a fax printer driver that allows this interface with Excel and VB. I think that Microsoft Fax probably has the capability but I don't have the skill. Thanks for your help.

 

[Harvey]

Am I right if I say that when you would fax it, you normally choose the fax in the print screen, type a number on the machine and press print?
If yes, you have to send the number to the machine somehow and then "print" it.

 

[CT Witter]

I've used this in the past. Relies on you having outlook installed.

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

HTH,
CT

 

[iphorum]

Thanks for the responses, I got bogged down in another project and didn't get back to you. I looked into the microsoft solution but it is for Win98. I'm using XL2002 and Win2000/XP. There seems to be some support issue with this earlier version.

I would think someone has solved this before.

Thanks for your help.