Sending Mail

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Eric,

We encountered the following situation in SQLServer 6.5 but NOT in 7.0:

Upon sending a MSProject file through e-mail to differenct people, the messages were still left in the OUTBOX. The messages had to be manually triggered before they were actually sent.

What could be the cause of this and how do we solve this problem.

Thanks, Chelo

-- Anonymous, March 29, 2000

Answers

Chelo,

Neil Pike, MVP/MCSE Protech Computing Ltd., provides this advice:

Q. Mail messages are stuck in my outbox with SQL Mail. They don't get sent until I login as the user locally and open the inbox manually. A. This is a mapi problem, not a SQL one - specifically with the mapi32.dll file. The one that comes with NT 4.0 as part of basic "Windows Messaging" does not work properly when called from a service. Versions of mapi32.dll that people have reported to work are:

The one in NT 4.0 SP3 (mapi32.dll doesn't ship in later sp's, so it has to be SP3)

Outlook 97/98 or a recent Exchange client

v5.5.1960.0 (size 884736 bytes)

Outlook 2000 definitely fixes the problem (Neil did this on a server recently). Another cause of the problem can be having offline folders enabled on the mail client. Make sure this isn't the case. Hope this helps,

Eric

-- Anonymous, March 31, 2000


Moderation questions? read the FAQ