If you're looking to create a macro, then you need to record the setps
involved in snding the file out.

Tools--Macros--Record new macros
"NSKearns" wrote:


Good Morning.

I would like to send the active workbook as a fax via a fax server
using outlook. In order to do this I select File - Send to - Mail
Recipient.

I then fill in the details 'From:', 'To:', 'CC:' and subject and hit
the send key.

I would like to automate this by means of a macro. Could someone please
help me.

Oh! I also need to ensure that the contents will fit on a sheet of A4
paper.

Thanks for all your help. I look forward to hearing from you.:)


--
NSKearns
------------------------------------------------------------------------
NSKearns's Profile: http://www.excelforum.com/member.php...o&userid=36948
View this thread: http://www.excelforum.com/showthread...hreadid=572102