Very Computer

Hi there,

Does anyone know a possible solution for this prob,
The prob is I've configured SQL Server 7.0 with Outlook 98 client for SQL
Mail.  Yes I followed the procedure defined by Microsoft for setting up a
user account for SQL Serve and SQL_Exec and create for that user Outlook
account and configure it. Everything works great.
xp_sendmail works (Even you logout), but all the emails are stored in outbox
of Outlook

Outlook is configured to send outgoing mails immidiately and check for new
ones every minute. But it never flushes the outbox mail, unless you logged
into the Server with the account for SQLExec and open Outlook98, then it
starts sending all that mail from outbox.

So, is there any solution to make it totally automated w/o having to logged
into the system and having Outlook open.
(i.e what if you logout, but your server still running)

Any help will be greatly appreciated

Hi;

Do you have a Personal Folder configured for your SQLMAIL outlook profile???

If so, that is most likely the problem. If you are using Exchange server,
just use the server folders and remove the personal folders. If you do not
have Exchange, then you'll need to do a little more work to ensure the mail
is sent.

Take a look at Q118501 (I know it's related to SQL6 but it has good info
anyway) at support.microsoft.com for more information...

Hope this helps...

Ted

Quote:> Hi there,

> Does anyone know a possible solution for this prob,
> The prob is I've configured SQL Server 7.0 with Outlook 98 client for SQL
> Mail.  Yes I followed the procedure defined by Microsoft for setting up a
> user account for SQL Serve and SQL_Exec and create for that user Outlook
> account and configure it. Everything works great.
> xp_sendmail works (Even you logout), but all the emails are stored in
outbox
> of Outlook

> Outlook is configured to send outgoing mails immidiately and check for new
> ones every minute. But it never flushes the outbox mail, unless you logged
> into the Server with the account for SQLExec and open Outlook98, then it
> starts sending all that mail from outbox.

> So, is there any solution to make it totally automated w/o having to
logged
> into the system and having Outlook open.
> (i.e what if you logout, but your server still running)

> Any help will be greatly appreciated

Thankx a bunch for answering the issue

Guess what microsoft have for a remedy

WORKAROUND
The following can be used as workarounds for situation number one mentioned
earlier:

  a.. Stop and restart SQLMail after a user has logged off the Windows NT
computer.

  b.. Use a password-protected screen saver so that you do not have to log
on and off of the server.

Is not that stupid or what, to run a screen saver on your server and keep
login

Nooruddin,
I had this problem a while back.  Check to make sure if you have the 824k
mapi32.dll (10/21/98).  If you do, you should try completly unistalling
Outlook 98 and and reinstalling it, make sure you have the 824 mapi32.dll
file and then complete the mail configuration.  If you want instructions on
how to use the Windows Exchange client, I can send them to you.

HTH