Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot send out Excel workbook through Outlook Express
Hi all,
I was trying to send out an excel workbook through Outlook Express. I looked at http://www.rondebruin.nl/ and have: Workbooks.Application.ActiveWorkbook.SendMail ", _ "This is a test" In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook' failed" I checked my Internet Option | Program and it has Outlook Express as the default Email. Any idea why? Thanks so much. Abel Chan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot send out Excel workbook through Outlook Express
Hi Abel
Your code is not the same as the Example on my site Sub Mail_workbook_1() ActiveWorkbook.SendMail ", _ "This is the Subject line" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Abel Chan" wrote in message ... Hi all, I was trying to send out an excel workbook through Outlook Express. I looked at http://www.rondebruin.nl/ and have: Workbooks.Application.ActiveWorkbook.SendMail ", _ "This is a test" In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook' failed" I checked my Internet Option | Program and it has Outlook Express as the default Email. Any idea why? Thanks so much. Abel Chan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot send out Excel workbook through Outlook Express
Hi Ron,
Thanks to your quick reply. I used your code and got error 1004 Application-defined or object-defined error. Somehow Excel was unable to find Outlook Express. On the other hand, I was able to use your code at: http://www.rondebruin.nl/mail/oebody.htm to bring up a dialog box and send out a test email. I also tried the Outlook object code and got similar error: Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject Thanks so much Ron. Abel "Ron de Bruin" wrote: Hi Abel Your code is not the same as the Example on my site Sub Mail_workbook_1() ActiveWorkbook.SendMail ", _ "This is the Subject line" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Abel Chan" wrote in message ... Hi all, I was trying to send out an excel workbook through Outlook Express. I looked at http://www.rondebruin.nl/ and have: Workbooks.Application.ActiveWorkbook.SendMail ", _ "This is a test" In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook' failed" I checked my Internet Option | Program and it has Outlook Express as the default Email. Any idea why? Thanks so much. Abel Chan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot send out Excel workbook through Outlook Express
See
http://www.rondebruin.nl/mail/problems.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Abel Chan" wrote in message ... Hi Ron, Thanks to your quick reply. I used your code and got error 1004 Application-defined or object-defined error. Somehow Excel was unable to find Outlook Express. On the other hand, I was able to use your code at: http://www.rondebruin.nl/mail/oebody.htm to bring up a dialog box and send out a test email. I also tried the Outlook object code and got similar error: Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject Thanks so much Ron. Abel "Ron de Bruin" wrote: Hi Abel Your code is not the same as the Example on my site Sub Mail_workbook_1() ActiveWorkbook.SendMail ", _ "This is the Subject line" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Abel Chan" wrote in message ... Hi all, I was trying to send out an excel workbook through Outlook Express. I looked at http://www.rondebruin.nl/ and have: Workbooks.Application.ActiveWorkbook.SendMail ", _ "This is a test" In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook' failed" I checked my Internet Option | Program and it has Outlook Express as the default Email. Any idea why? Thanks so much. Abel Chan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The "Send To" option should use Outlook Express but uses Exchange | Excel Discussion (Misc queries) | |||
Fw: send two or more files with Excel and Outlook Express | Excel Discussion (Misc queries) | |||
How do use outlook express to send email in office 2003 | Excel Discussion (Misc queries) | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) | |||
Send a range in Excel as the body of an Outlook Express message | Excel Programming |