how to get the correct email format when sending email using sqldatareader

[rote]

I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(sma il);

//this.Label1.Tex t = smail;

Response.Write( smail);

}

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

Well, here you have a work around (it could be better coded, but this will
work for you), just add the semicolon before and in the first ocurrence don't
do the concat:

bool firstTime = true;

while (oledr.Read())
{
smail ="";
if(!firstTime) smail = ";"
smail += oledr[0].ToString();
}

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"rote" wrote:

I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(sma il);

//this.Label1.Tex t = smail;

Response.Write( smail);

}

[Eliyahu Goldin]

This code will always produce only the last email. It can be a bit corrected
as:

smail ="";
while (oledr.Read())
{
if(smail.Length 0) smail += ";"
smail += oledr[0].ToString();
}

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Braulio Diez" <br************ **@yahoo.eswrot e in message
news:23******** *************** ***********@mic rosoft.com...

Well, here you have a work around (it could be better coded, but this will
work for you), just add the semicolon before and in the first ocurrence
don't
do the concat:

bool firstTime = true;

while (oledr.Read())
{
smail ="";
if(!firstTime) smail = ";"
smail += oledr[0].ToString();
}

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"rote" wrote:

>I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(sma il);

//this.Label1.Tex t = smail;

Response.Write (smail);

}

[rote]

Thanks but
Tried what you suggested like this
bool firstTime = true;

while (oledr.Read())

{

string smail;

smail = "";

if (!firstTime)sma il = ";";

//smail = oledr[0].ToString();

smail += oledr[0].ToString();
//mail.To.Add(sma il);

Response.Write( smail);

}

But didn't solve the problem

"Braulio Diez" <br************ **@yahoo.eswrot e in message
news:23******** *************** ***********@mic rosoft.com...

Well, here you have a work around (it could be better coded, but this will
work for you), just add the semicolon before and in the first ocurrence
don't
do the concat:

bool firstTime = true;

while (oledr.Read())
{
smail ="";
if(!firstTime) smail = ";"
smail += oledr[0].ToString();
}

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"rote" wrote:

>I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(sma il);

//this.Label1.Tex t = smail;

Response.Write (smail);

}

[rote]

I'm getting multiple duplicate records using ur code?
any ideas

"Eliyahu Goldin" <RE************ **************@ mMvVpPsS.orgwro te in
message news:ef******** ******@TK2MSFTN GP02.phx.gbl...

This code will always produce only the last email. It can be a bit
corrected as:

smail ="";
while (oledr.Read())
{
if(smail.Length 0) smail += ";"
smail += oledr[0].ToString();
}

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Braulio Diez" <br************ **@yahoo.eswrot e in message
news:23******** *************** ***********@mic rosoft.com...

>Well, here you have a work around (it could be better coded, but this
will
work for you), just add the semicolon before and in the first ocurrence
don't
do the concat:

bool firstTime = true;

while (oledr.Read())
{
smail ="";
if(!firstTim e) smail = ";"
smail += oledr[0].ToString();
}

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"rote" wrote:

>>I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(sma il);

//this.Label1.Tex t = smail;

Response.Writ e(smail);

}

[Mark Rae [MVP]]

"rote" <na********@hot mail.comwrote in message
news:uB******** ******@TK2MSFTN GP03.phx.gbl...

Response.Write( smail);

Response.Write( smail.TrimEnd(' ;'));
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[rote]

Error
The specified string is not in the form required for an e-mail address.
is it "; "or ", "
tried all with no success
Using
using System.Net.Mail ;

Anu ideas this is driving me nuts

Thanks Mark

[MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:eu******** ******@TK2MSFTN GP04.phx.gbl...

"rote" <na********@hot mail.comwrote in message
news:uB******** ******@TK2MSFTN GP03.phx.gbl...

>Response.Write (smail);

Response.Write( smail.TrimEnd(' ;'));
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Eliyahu Goldin]

Fantastic.Never paid attention to this method.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Mark Rae [MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:eu******** ******@TK2MSFTN GP04.phx.gbl...

"rote" <na********@hot mail.comwrote in message
news:uB******** ******@TK2MSFTN GP03.phx.gbl...

>Response.Write (smail);

Response.Write( smail.TrimEnd(' ;'));
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"rote" <na********@hot mail.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

Error
The specified string is not in the form required for an e-mail address.
is it "; "or ", "
tried all with no success
Using
using System.Net.Mail ;

Any ideas this is driving me nuts

Oh right - now I see what you're trying to do...

while (oledr.Read())
{
mail.To.Add(ole dr[0].ToString());
}

http://www.systemnetmail.com/faq/3.2.3.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[rote]

Thanks but when i do that i get error:
The parameter 'addresses' cannot be an empty string.
Parameter name: addresses

"Mark Rae [MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

"rote" <na********@hot mail.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>Error
The specified string is not in the form required for an e-mail address.
is it "; "or ", "
tried all with no success
Using
using System.Net.Mail ;

Any ideas this is driving me nuts

Oh right - now I see what you're trying to do...

while (oledr.Read())
{
mail.To.Add(ole dr[0].ToString());
}

http://www.systemnetmail.com/faq/3.2.3.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net