SQl Mail & SMTP Mail...

• Bidec

  SSCommitted

  Points: 1666

  More actions

  April 26, 2004 at 9:36 am

  #66364

  H All,

  We all did some comparision between SQL mail and SMTP mail in the article :

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=112330

  After that I have started using XPSMTP mail in our development environment. I was able to configureit properly and send email from SQL server.

  But now my question is how to I send mails to SQL server, and how do I make sp_processmail work with it ? With SQL Mail I was able to use XP_SendMail and SP_Processmail without any problems. But with SMTP mail I am really confused and I dont really know how should I browse thru sql emails  like I was able to do in SQL Mail using  xp_deletemail, xp_findnextmsg, xp_readmail.

  Any help is really appreciate.

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  April 26, 2004 at 10:21 am

  #504252

  You need to configure SQLMail to do the reading. These stored procedures only work with the MAPI interface in a client like Outlook.

  You could also do some processing of mail using CDO. Here's one article looking at this: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncdo121/html/collabdataobjs.asp