I set up SQL 2000 SP3 SQL Mail under one of my MAPI Profiles in Outlook 2003 so that I can send an email from an extended stored procedure in SQL. This works fine ONLY when my Outlook 2003 is open with that profile.
The message is made by SQL and plops in my Inbox. Yes you heard that right. My Inbox. After a few seconds the e-mail message will be sent. But that is really no good. I need the message sent when it is made. Not after I open Outlook 2003 using that profile.
Is there any way I can convince Outlook 2003 to send the message once this message gets inside the Inbox? I am assuming the Inbox exists even though Outlook 2003 has not started. Any ideas?