**UNRESOLVED**FAX word doc via code only

[LevelOne]

I need to know how to send a fax when a user presses a button on a sheet. I don't want any user interaction other than pressing the button to send the active sheet. I am the using the Micrsoft Shared Fax program in SBS 2000 and Excel 10. I can handle the placing of the objects and pulling the correct fax number as a variable from the sheet. I just need to know the code to actually send to the network fax.

Thanks.

[si_the_geek]

can you do it manually? if so just record a macro of it - the code will be written for you

[LevelOne]

Well, I figured out a way to fax through Outlook, I enabled Fax Mail Transport. But the problem is this, when I enter the recipient the way Outlook needs it to FAX, e.g. [FAX:555-5555] the code does not work, it kicks back the e-mail. But if I manually enter it in the To: field it works.

Any ideas?

I am having to create templates to prevent the rash problem of users faxing to the wrong client. We send out about 300 faxes a day. I created contacts in W2K Server that works with the MS Shared Fax program, but they still @#$% it up.

God I wish their brains had a VB Editor.

As a side note, I am going to have to use Word to do this, whenever the Mail program creates the Tiff image to send, it cannot render multiple sheets, but Word will work just fine for what I am doing.

Thanks.