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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-31 : 09:09:55
|
| Mcgrath writes "Hi,I've a table with a column called MAIL_ATTACHMENT of type nText and ATCH_TYPE of varchar(3).MAIL_ATTACHMENT could contain binary data of any document(Word, excel, ppt ) microsoft supported.ATCH_TYPE tells us the type of attachment.My Question is to how to read the MAIL_ATTACHMENT from the table and convert into appropriate documents and then it has to be attached in a mail. This has to be done in xp_sendmail.how it can be achieved using Transact SQL Procedures?Help is required in this regard?Regards,Mcgrath" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-07 : 12:04:45
|
| i would try to send it as HTML and use MIME header. |
 |
|
|
|
|
|
Sending mail with attachments by reading ntext columns.