email to multiple addresses?

[JT]

I know how to send email from a database using vb and an email address field in the database. But does anyone have a suggestion how to send the email to all the values in the email field simultanuously?

[parkes]

Not quite sure what you mean by the last part, but if your trying to send email to more than one person you need to seperate each address with a ;. If this isn't what you mean let me know and I'll see what I can do

[JT]

Yes. that is what I meant. The problem is that I might have 500 records with email addresses, and that one letter must be sent to all 500. I see what you mean by adding a ";" but how can I automate the process?

[parkes]

You would put the whole thing in a loop

table.movefirst
strEmail=table.field("???")

do until table.eof
strEmail=strEmail & ";" & table.field("???")
table.movenext
loop

Hope this make sense

[JT]

Thanks Parks, I'll try it out.

[JT]

Correction, "Parkes".

Sorry