|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 16th, 2006, 09:10 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Need to send a fax via a fax server from excel
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 
|
|
#2
August 16th, 2006, 01:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to send a fax via a fax server from excel
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
|
|
#3
August 16th, 2006, 02:10 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to send a fax via a fax server from excel
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. -- NSKearns ------------------------------------------------------------------------ NSKearns's Profile: http://www.excelforum.com/member.php...o&userid=36948 View this thread: http://www.excelforum.com/showthread...hreadid=572102
|
|
#4
August 16th, 2006, 03:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to send a fax via a fax server from excel
Hi,
I've recorded plenty of macros which use menu commands. Dave "NSKearns" wrote: 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. -- NSKearns ------------------------------------------------------------------------ NSKearns's Profile: http://www.excelforum.com/member.php...o&userid=36948 View this thread: http://www.excelforum.com/showthread...hreadid=572102
|
|
#5
August 16th, 2006, 03:07 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to send a fax via a fax server from excel
Hi Dave, Well if you could maybe give me a little more information I would be really grateful. Thanks. -- NSKearns ------------------------------------------------------------------------ NSKearns's Profile: http://www.excelforum.com/member.php...o&userid=36948 View this thread: http://www.excelforum.com/showthread...hreadid=572102
|
|
#6
August 16th, 2006, 03:25 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to send a fax via a fax server from excel
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 "NSKearns" wrote: Hi Dave, Well if you could maybe give me a little more information I would be really grateful. Thanks. -- NSKearns ------------------------------------------------------------------------ NSKearns's Profile: http://www.excelforum.com/member.php...o&userid=36948 View this thread: http://www.excelforum.com/showthread...hreadid=572102
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
