Here's an easy one for you
-
I have about 30 pages that are identical except for minor things. Here's the scenarion: A person selects multiple recipients for a message, let's say they pick COLLECT1 and COLLECT2. I want to send a different message to COLLECT1 than COLLECT2 and include the information that the "user" has provided. The code for the two pages for gaining the email address and sending the email is indentical. There are no errors when the user submitts the request, but the email only reaches whoever was chosen first on the list. Now, the recordset is set to nothing and the mail object is set to nothing at the end of each mailing. The only thing I don't know how to do is make the "email" object from the following code go away. I mean, if I go to the page of the second possible choice, COLLECT2, and change the "email" to "email2", then it works. I need to know how to make the "email" object go away at the end of each form so I don't have to go throgh all my pages, renaming the "email" object 1, 2, 3, 4 and so on. Here's the code: SQLGETEMAIL = "SELECT email FROM DSAUsers WHERE profile = 'APLINEP'" SET RS = MyConn.Execute(SQLGETEMAIL) Do until RS.EOF = True email = email & RS("email") & ";" RS.movenext loop ' Get rid of the final ; If email <> "" Then email = Left(email, Len(email) - 1) End If ####### Then I use CDONTS to send the mail...now, how do I remove any trace of a page being processed so the next one looks like the first? Does this make sense?