Hi,

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

I am trying to send an excel sheet via a fax server using outlook however I am having problems as I need to change the 'FROM:' criteria 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 of A4 when it is received at the other end.

I hope someone can help me.

Thank you.