I have a form on emails.asp with a textarea input field. I want to enter emails line by line and then submit to results.asp which will filter recordset column named emails and show me all emails matching emails entered into the text area. I am pretty new to custom SQL statements..Please Help!!

It works well when I enter 1 email but when 2 or multiple emails are entered errors arise.. I thought about creating an array but, I do not know how to incorporate an array into an SQL WHERE statement.

Edited by - dllk95 on 29 Nov 2003 07:51:33

Edited by - dllk95 on 29 Nov 2003 07:52:09

I'm not sure if you're talking about using a specific extension, or existing pages from some application... but in general you can use semicolons as delimiters to separate email addresses in a textarea, and assuming you're talking about using the CDO email function, CDO will send to all of the addresses.

Thanks eswelsh.. I was able to figure out this task which is pretty simple..
Took it from this tutorial...

www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=4233