Hi Guys,
I am trying to send email in one of my code , but the email need to be sent to the list of people which comes from a store procedure.

Then I change the recordset into a string containing all the email ids.
The only thing I am getting problem is in what format do I need to write the following syntax:
sendmail.To = stringname
Is this the right way , if not can anyone pls tell me the right one.
cheers

Multiple recipients on the list are separated by semicolons:
sendmail.To = "[email protected];[email protected];[email protected]"


Om Prakash

Ya I know that email id are separated by ";" but it is in a string
as
str = [email protected];[email protected]

And I need to present this in the sendmail.TO thing.

It doesnt work if I simply says:
sendmail.To = str.

Any advice?

It doesn't matter if the data is in a string or hardcoded. If you specify the list in "To" field, then it will send mail to multiple receipients. Please check the following example:

<%
Dim objNewMail

Set objNewMail = Server.CreateObject("CDONTS.NewMail")
str = "[email protected];[email protected]"
objNewMail.From = "[email protected]"
objNewMail.To = str

objNewMail.Subject = "This is a test Mail"
objNewMail.Body = "This is the Body text of this test mail."
objNewMail.Send

Set objNewMail = Nothing
Response.Write "Email has been sent"
%>

The source of str variable can be anything.
you can send mail to 2 recepients using above code..

Om Prakash

I believe that is COMMA, not semicolon.

Cheers!

_________________________
- Vijay G
Strive for Perfection