I am looping through a sql statement using a reader and sending emails. It works when I only use 1 recipient. But I cannot seem to get the syntax to send to multiple. I am getting "invalid character" at the semi-colon in the "To" address line. please
see code.
Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString()
Dim checkSql As String = "SELECT Members.MemEmail1, Members.MemEmail2 FROM Members"
Using myconnection As New SqlConnection(ConnectionString)
Dim command As New SqlCommand(checkSql, myconnection)
myconnection.Open()
Dim reader As SqlDataReader = command.ExecuteReader()
Try
While (reader.Read())
Di ...
Go to the complete details ...