May 22, 2006 at 2:01 pm
When I try to send a email by using a Send Mail Task the task completes successfully but the email never arrives. When I then go into outlook I see the email appear in the sent email folder. I then receive the email.
Thanks for any Help.
Jo
May 22, 2006 at 2:23 pm
What version of outlook is it?
Outlook 97/98 requires you to leave the outlook open othersise the mail will get stuck in the outbox.
hth
David
May 22, 2006 at 2:29 pm
May 22, 2006 at 2:33 pm
Very bored tonight
If all else fails have a look at these posts and you can bin outlook.
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=187&messageid=133926
This solution works well.
David
May 22, 2006 at 2:35 pm
i'm using outlook 2000.
May 22, 2006 at 2:44 pm
I probably should haved mentioned that the profile is configured to use SMTP/POP and both work fine from outlook.
Thanks
Jo
May 23, 2006 at 7:03 am
I'm not sure how you have things configured, but on my server I have to leave Outlook open because I have a interval of 5 minutes on my send/receive and it won't run unless Outlook is open.
CRC
May 23, 2006 at 12:26 pm
Do you actually have a valid account set up for SMTP? Or is is your company allowing you shoot your SQL mail through a company SMTP server w/o an account? If not you'll want to leave the "remember password" checkbox left unchecked. I've had similar issues using Outlook 2000 and SMTP and sqlmail. Typically, what happens is that it'll send out the first email after which it'll check for any incoming mail....but the authentication will fail because account doesn't exist so it'll hang and any future emails will get stuck in the outbox until SQL server is restarted. XP_send will continue to run sucessfully and won't return any errors through SQL Server.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply