Can't send email automatically outlook 2007

[lopezio]

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.

[Leith Ross]

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.

[lopezio]

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

Please Login or Register  to view this content.

But I don't like it because I have to open outlook and kill the process.
Any ideas?