Hi All,

I will be hosting my website using a hosting package and the ones i have seen do not allow the use of the database mail. So what is the best way to do this? I have a table that is called unsentmail in my db which contains the rows. the columns are to, subject,  body...

Any ideas?

Hi,

If you cannot use Database mail, I think you can try SQL Mail instead, which provides a way to send, receive, delete, and process e-mail.

Please refer to the documents below:

SQL Mail
http://msdn.microsoft.com/en-us/library/ms177418(SQL.90).aspx

How to configure SQL Mail to use an Internet mail server by using Outlook 2003
http://support.microsoft.com/kb/897349

SQL Mail vs Database Mail
http://www.siusic.com/wphchen/sql-mail-vs-database-mail-102.html

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.