Now i want to send an email notification to different mailling list considering the choice in the droplist.
strSql = "SELECT M_EMAIL FROM " & strMemberTablePrefix & "MEMBERS"
strSql = strSql & " WHERE M_NAME = **********"
Set rs33 = Server.CreateObject("ADODB.Recordset")
rs33.open strSql, my_Conn
email = rs33("M_EMAIL")
rs33.Close
set rs33 = nothing