Author: bootzilla | Posted on: 11/12/2008 11:53:21 AM | Views : 283

I have a drop down list where you can select one email address or all if it contains more than one email address. Does anyone know how I would do this? Here is the code for how I populate the dropdown box  and the Auto Email:
Public Sub fillMonthlyDownloadsDropDownList()

Try

conn = New SqlClient.SqlConnection(strconn)

conn.Open()

Dim currentAll As String

Dim strSQL = "SELECT d.group_descr, a.first_name, a.last_name, a.user_id, b.email, d.group_id, d.parent_group_id FROM icc_user_data AS a LEFT OUTER JOIN icc_users AS b ON a.user_id = b.user_id LEFT OUTER JOIN icc_users_groups AS c ON a.user_id = c.user_id LEFT OUTER JOIN icc_groups AS d ON c.group_id = d.group_id WHERE (b.user_id NOT IN (249)) AND (d.group_id IS NOT NULL) AND (d.group_id <> '8') ...

Go to the complete details ...