email to multiple addresses?

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?

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

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?

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

Thanks Parks, I'll try it out.

Correction, "Parkes".

Sorry