Hi,

I am currently trying to automate a procedure that sends the activ
worksheet as a fax.

I am trying to send an excel sheet via a fax server using outloo
however I am having problems as I need to change the 'FROM:' criteri
and I am unable to do this.

What I want to do is on the existing sheet click on File - Send To -
Mail Recipient.

Then enter the details (From, To, CC, and Subject)

I then want to send the sheet. :)

I also want to ensure that the sheet will fit onto a standard sheet o
A4 when it is received at the other end.

I hope someone can help me.

Thank you

--
NSKearn
-----------------------------------------------------------------------
NSKearns's Profile: http://www.excelforum.com/member.php...fo&userid=3694
View this thread: http://www.excelforum.com/showthread.php?threadid=57178