Jmail (sending to multiple recipients)

[krappleby025]

Hi all,

i am currently using a JMAIL script on many of my webpages, and am having a little problem with the programming. i hope someone can help. let me explain the situation.

I have a database that may have over 100 email addresses in it, and i need to send an email to everyone in that list, now, i can arrange the script so that every email is sent as a seperate, however, that takes forever using the email package i have, i need to send the email to say 20-50 people at a time, using a multi to field, ie in normal emails you can put

kap@kap.com; test@test.com; r@r.com; d@d.com

but in this script i cannot...

here is the section that this is in corespondence to

receiver = query2("email&quot
sender = "TheTeamleads@krapp.nl"
subject = "message from your upline - " & subject
body = "" & message
Set mail = CreateObject ("JMail.SMTPMail&quot
mail.ServerAddress = smtpServer & ":" & smtpPort

now as you can gather this is sent to a database field called Query2("email&quot however this is only one person at a time, i need to send it to many, any suggestions, i have tried adding a

to = "me@me.com; " & query2("email&quot

which should have sent to two people but it doesnt. i can easily set up a script likje

to = "me@me.com; "
DATABASE CONNECTION
do until query2.EOF
to = to & query2("email&quot & "; "
query2.movenext
loop

Done it before but it didnt work. can anyone help

thanks

keith
kappleby@krapp.nl

 

[GaryC123]

Try
Mail.Addrecipient "someone@somewhere.com;someone@somewhere.com etc"