I have a send mail task that is not immediately sending the e-mail. What
happens is the e-mail doesn't go out until I open Outlook 2003 (on XP) and
hit Send/Receive I even see it saying "sending 1 message" when there is
nothing in my outbox.

The profile in the send mail task is 'Outlook'. There is no attachment,
just a short message. SEM is version 8.0.

Thanks for your help,
Al

The Send Mail task uses the same MAPI setup as SQL Mail and SQL Agent Mail.
MAPI is the devil spawn. Basically it is not designed for server side or
unattended operations, and consequently is not very reliable.

For maximum reliability my personal recommendation is Outlook 2000 coupled
with a local exchange server.

Your actual problem is described here-
315886 - INF: Common SQL Mail Problems
(http://support.microsoft.com/default...6&Product=sql2
k)


Personally I avoid the Send Mail Task because of the MAPI associated
problems, and prefer to use xp_smtp_sendmail via an Exec SQL Task.
(http://www.sqldev.net/xp/xpsmtp.htm)


--
Darren Green
http://www.sqldts.com




"Al Cadalzo" <cadalzo (AT) hotmail (DOT) com> wrote

Darren,

Thanks so much for your reply.
I'll take a look at the KB article and I'm also going to start using
xp_smtp_sendmail via an Exec SQL Task instead of the Send Mail Task.

Best regards,
Al

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote