Emailing File from SQL Server Database
Hello Everyone and thanks for your help in advance. I have a document repository stored within a SQL Server database. The files are stored as images with the tables. They are various document types including Word, Execel, and PDF. I want to be able to email these files to recipients as attachments. I know how to retrieve these documents and write them to the browser and I know how to use System.Web.Mail, but I cannot figure out how to attach these files. Do they have to be saved to the hard drive first, or can I simply stream it? Any help on this topic would be greatly appreciated. Thanks.