I want o send an email from excel but I have to open the outlook otherwise the mail is not sent. Why the command oEmail.Send doesn't work. Any idea?
Here is my code
![]()
Please Login or Register to view this content.
I want o send an email from excel but I have to open the outlook otherwise the mail is not sent. Why the command oEmail.Send doesn't work. Any idea?
Here is my code
![]()
Please Login or Register to view this content.
Hello lopezio,
I don't have Outlook 2007 but Outlook 2010 won't send the email unless the inspector for the inbox is active. Here is the code I use for Outlook 2010...
![]()
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Ross
got error in outlook 2007, in instruction send
Here is the error
Application-defined or object-defined error
This code works in outlook 2007
But I don't like it because I have to open outlook and kill the process.![]()
Please Login or Register to view this content.
Any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks