GavinC 0 Newbie Poster

Hi there

I have to create a couple pages where I need to, in the end, send an email through ASP.

I have done a couple of previous pages and they seem to be working pretty fine. However, I need to now send attachments in ASP Email.

I went to go read up a bit about it and saw that with adding .AddAttachment = (file location) this is possible. This is just with 1 attachment, what if I need to send multiple attachments. To throw some more gasoline on the fire I need to retreive the paths out of an Access Database. Every path is in a different row.

When I do a while loop statement, and response.Write the query I get what I want and need.

The question on the other hand is how can I get all the paths into 1 variable and set that as the attachment needed to be sent.

Is it possible or what can be done