Hi folks,

I have file attachments stored in a SQL Server 2000 table that has a field type of Image. I can read, display, and write these files to and form the database without any problems. I am using VB.NET and ASP.NET.

I want to be able to send these out as email attachments without having to save them to disk first, if possible. If it is possible, somehow I would need to set the SMTP object's mail attachment name and have it accept the stream from a binaryreader. Is this possible. I've not had much luck.

Would saving the file to disk first, attaching and sending it, then deleting it be the only way? I was hoping to avoid the additional I/O for this process, as there are many different files attachments to be sent to different people all of the time. This is part of an "eLearning" application, with an end user pool of ~5000 users.

Thought are appreciated,