System.FormatException: The specified string is not in the form required for an e-mail address.

Quote:

System.FormatException: The specified string is not in the form required for an e-mail address. at System.Net.Mime.MailBnfHelper.ReadMailAddress(String data, Int32& offset, String& displayName) at System.Net.Mime.MailBnfHelper.ReadMailAddress(String data, Int32& offset) at System.Net.Mail.MailAddressCollection.ParseValue(String addresses) at System.Net.Mail.MailAddressCollection.Add(String addresses) at Admin_newsletter.HtmlEmailTemplate() in d:\hosting\9780189\html\Admin\newsletter.aspx.cs:line 143

string[] recipients = new[] { "teke@gmail.com", "dan.jojo@gmail.com" };

            DataTable dt = _UserInfo.GetUserAllByEmail();
            string bccAddresses = "";
            string Address = "";
            mailMessage.From = new MailAddress("sales@gmail.com", "We have big Deals for you!");
            mailMessage.To.Add("dan@gmail.com");
            foreach (DataRow drRecipient in dt.Rows)
            {
                bccAddresses = bccAddresses + " " + drRecipient["Email"].ToString() + ",";
                Address = bccAddresses.TrimEnd(',');
            }
            mailMessage.Bcc.Add(Address);
            mailMessage.Subject = "Test Email";
            mailMessage.IsBodyHtml = true;

ALTER PROCEDURE [dbo].[GetUserByEmail]

AS
BEGIN

    SELECT U.UserName as Email from [User] U
    left join [Member] M on M.UserId=U.UserId


END

mailMessage.Bcc.Add(Address);