Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ms41048
Starting Member
2 Posts |
 Posted - 2007-08-06 : 05:41:10
|
| Hi, I have configured MAPI profile using POP3 and the same profile has been configured in SQL server 2000 in SQL server Agent(Management) and in SQL Mail(Support Services).Mail is sent successfully when we compose it manually through Microsoft office outlook.The problem is that when i execute XP_sendmail stored procedure is executing fine and the output is Mail Sent.But the mail is remaining in outlook itself.When i open the outlook Send/Receive is happening and the mail is sent successfully.Unless i open outlook Iam unable to send the mail.Please suggest me what would be the possible solution for this.Any help from you side is appreciated.Thanks in Advance.regards,Shaik. |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-08-06 : 06:46:45
|
| I think this is something to do witih outlook, isnt there a option that you can automate the send and receive through outlook, else use thunderbird it is better in my opinion. |
 |
|
|
ms41048
Starting Member
2 Posts |
Posted - 2007-08-06 : 07:00:11
|
| Hi Jim, Thanks for your response.I have checked the same.I found out that there is option of setting Schedule send/Receive check box for a defined time(1 minute is the lower threshold).Even though its same problem.And i dont know about Thunderbird option.Could you explain me what it means and where is that option.regards,Shaik. |
|
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-08-06 : 10:04:26
|
| http://www.mozilla-europe.org/en/products/thunderbird/Thunderbird is just a email application which I find sends and receives email better than outlook with less difficulty to set-up, but I have used both with xp_sendmail and there has never been a problem, sorry I can't help further. |
|
|
|
|
|
|
problem with pop3 mail box