Formula for Faxing through Outlook?

[Heyna]

Hi All;
I have a Spreadsheet which has a Primary Pull-Down list made throug
Validation of cells, motivated by a Named List. (Ex: B39 pulls down t
choices of Plumbing, Electrical, etc.) There is an adjacent Validatio
list that is motivated by A series of named lists broken down to th
trades from the first validation list with the names of subcontractor
involved with that list.( Ex: C39 pulls down to (Bob's Plumbing, Supe
Plumbing if "Plumbing has been chosen in B39). I've made two adjacen
cells (Ex39,E39) that fill-in through use of a Lookup list: the firs
cell is for Fax numbers, the second is for email addresses. I'm usin
the following Formulas in the cells to get the proper email addresse
and fax numbers to appear as the words" Send Fax" and "send Mail"
respectively (so that they fit in the spreadsheet cell) and hyperlin
directly to Outlook (open up a "new mail" when you click):

For email:
=IF(C39="","",HYPERLINK(CONCATENATE("MailTo:",VLOOKUP(C39,SubNumber,3,0)),"Sen
Mail"))
NOTE: SubNumber is the name to the Table Array in both

For Fax:
=IF(B39="","",HYPERLINK(CONCATENATE("MailTo:+
",VLOOKUP(C39,SubNumber,2,0)),"Send Fax"))
I'm using outlook because the company wants faxes to digitally send
and this way I can do attachments. It is rickety, at best, as it onl
shows the fax number in the To: position, we have no cover sheets, etc
We use MSFAX to digitally fax, but I can't seem to find a way to ge
it to work with Excel within a spreadsheet. I would love to be able t
work with MSFAX, and if anyone has a clue, please let me know.
However, if there is a good code to do faxes in a better way from Exce
spreadsheets, please let me know. Treading water, here.... ha-ha.
Many thanks,
Scot