sqlmail

[mgid]

I've set up sqlmail correctly, I think, but the messages keep hanging in the outbox on the server. They will deliver if you manually deliver them from the server. I'm using a standard windows messaging, sql 7, win nt, etc. Any help would be appreciated. Thanks.

 

[jhall156]

are you using sp_ProcessMail or the associated xp's individually? JHall

 

[mgid]

I'm just sending mail with xp_sendmail.

Is it necessary to execute sp_processmail after xp_sendmail?

 

[jhall156]

Nope, I'm perverting the use of these xp's myself to take email orders from a third party source, parse them and enter them into a heterogenous (Visual FoxPro) accounting package. Can you tell me more about what you're doing? JHall

 

[mgid]

I'm having the database send an email to field-based managers from a customer issue/complaint system through a trigger. It all seems to work but, like I said, the messages appear in the outbox and just hang there until manually delivered. I set the check for messages setting to 1 minute and can't find any other settings that would cause this to happen.

 

[jhall156]

What's your MAPI client? Outlook 2000? JHall

 

[mgid]

I'm using the windows messaging client. Do you think a switch to Outlook could help the situation?

 

[jhall156]

I'm really not sure. I don't think it can hurt. Have you tried sending a plain text test msg to yourself from Query Analyzer? Perhaps MSMAPI is choking on something or not finding something that is forcing a manual send. JHall

 

[mgid]

From a whitepaper, turns out the original win NT mapi32.dll file was bad, they released a fix in service pack 3 in 97, but did not include the fix in future service packs because of possible "product incompatibilities." That file fixed the problem.