Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm experiencing unusual behavior using Office Basic Edition 2003 on an IBM
Thinkpad running win XP Pro Sp2. When I attempt to run the following code Public Sub SendMe() ThisWorkbook.SendMail ", "Test", False End Sub I get Run-time Error 1004, 'Application-defined or Object-defined error' I have Outlook Express set as my default email prog, and I have the secutiry feature turned off for warning if other progs try to send email as me. This code works fine under identical conditions on my desktop but not on this laptop. My desktop does have Office 2003 Pro instead of Basic, however. Any ideas? Should I reinstall office? I already tried repairing it via Control Panel applet. Thanks, William |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In case anybody's still monitoring this question, we found that this bug
occurred when Office was installed *without* installing Outlook, even though we were not using Outlook as an email client. After installing Outlook, the code worked as expected. Apparently the Outlook installation adds the emailing functionality to the entire suite. William "William Barnes" wrote in message ... I'm experiencing unusual behavior using Office Basic Edition 2003 on an IBM Thinkpad running win XP Pro Sp2. When I attempt to run the following code Public Sub SendMe() ThisWorkbook.SendMail ", "Test", False End Sub I get Run-time Error 1004, 'Application-defined or Object-defined error' I have Outlook Express set as my default email prog, and I have the secutiry feature turned off for warning if other progs try to send email as me. This code works fine under identical conditions on my desktop but not on this laptop. My desktop does have Office 2003 Pro instead of Basic, however. Any ideas? Should I reinstall office? I already tried repairing it via Control Panel applet. Thanks, William |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 VBA problem - extracting and emailing worksheets | Excel Discussion (Misc queries) | |||
Emailing | Excel Discussion (Misc queries) | |||
Code problem emailing range as html in Outlook body | Excel Programming | |||
Emailing using VBA | Excel Programming | |||
Macro Emailing Challenging Problem | Excel Programming |