Email Attachment (ASP/VBScript/Access)

[RJ]

I would like to generate an email that contains a 'people.txt' attachment.
The attachment is dynamically generated consisting of a list of names from
an Access database. Is this possible to do without first having to save a
file to disk, or without installing any additional DLLs? My host will not
allow either.

The site is in ASP/VBScript/Access but the server does support .NET.

Thanks for any suggestions,
-RJ

 

[Armando]

Does your host allow you to send asp-generated emails? If not then I don't
see how this is possible. The most common method for creating emails in asp
that I know of is by using CDOSYS which is a DLL included in Windows. CDONTS
is out-dated as it is very limited in it's functionality.

Aside from that, I don't know of a way to dynamically create a file and
attach it to an email, however I suspect one thing you could try is when you
specify the attachment in your email-generating code, have it call a
function which creates the text file. That may work, but without testing I
can't be 100% sure. I'll give it a try sometime tonight and let you know
what I come up with.

Armando

 

[RJ]

Armando,

We've been trying to find a solution to this for some time. If only we could
reference a file in memory, or include a binary in a database field, we'd
have something to try. But, we're just not experienced with this sort of
thing.

Looking forward to your findings and thanks!
-RJ

 

[Chris Hohmann]

I would like to generate an email that contains a 'people.txt' attachment.
The attachment is dynamically generated consisting of a list of names from
an Access database. Is this possible to do without first having to save a
file to disk, or without installing any additional DLLs? My host will not
allow either.

The site is in ASP/VBScript/Access but the server does support .NET.

http://msdn.microsoft.com/library/en-us/cdosys/html/_cdosys_manually_adding_attachments.asp

HTH
-Chris Hohmann

 

[RJ]

Thanks Chris!

http://msdn.microsoft.com/library/en-us/cdosys/html/_cdosys_manually_adding_attachments.asp

HTH
-Chris Hohmann