Need to send a fax via a fax server from excel

[NSKearns]

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.

 

[Dave F]

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]

Thank you for your reply. I know how to record macros but unfortuantely
you are unable to record macros that involving selecting anything from
the menu.

I need VB for this to work properly. I have already written a macro but
it involves opening Outlook and sending the file as an attachment but
this doesn't work to well.

Thanks.

 

[Dave F]

Hi,

I've recorded plenty of macros which use menu commands.

Dave

 

[NSKearns]

Hi Dave,

Well if you could maybe give me a little more information I would be
really grateful.

Thanks.

 

[Dave F]

I would record the actions via a macro and look at the VBA code that returns
once the macro is saved.

That would point you in the right direction as to the code you need to use.
Unfortunately I'm not familiar with fax servers or how Excel communicates
with Outlook via VBA so I really can't offer anything more concrete than that.

Dave