Sending mail with an attachment by reading Ntext. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sending mail with an attachment by reading Ntext.


Can any one help me with the code how to Send a mail with an attachment,from SQL Server. by reading a column which is of type ntext and another column file_type. This has to be done using SQL Server Stored Procedure. Following are the scenario Table Employee EmployeeId
Name
Mail_Doc(ntext)
File_type(Word or Excel or PPT or Outlook or any micrsoft supported types) File Type determines the type of the file to be sent as an attachments. mail_doc contains the actual contents of the document.
software engineer
maybe this sample will help you up: http://www.sqldev.net/xp/xpsmtp.htm
]]>