Email tidy up possible?

[madanthrax]

I have made a small intranet asp application which when a new report is published an email notification should be sent to about 25 people. The recipients email addresses are in an sql table. The recipients change often and the operators with admin rights on the app can update the user list themselves.

I can get the DB addresses to appear on a test asp page using the While .... Wend thingy with a nice semicolon spacer between each address.

However I can't figure out how to put all the addresses into a variable that I can put into the 'To' field of the CDO mail.

I know you could put the whole CDO code into the loop and send 25 individual emails, but this seems messy to me.

Any tidy ideas please?

Thanks in advance for any help.

Anthony

[sub]"Nothing is impossible until proven otherwise"[/sub]​

 

[timpea]

Dim varTo
While Not DB.EOF
varTo = varTo & DB("emailaddress") & "; "
DB.MoveNext()
WEND

Then put varTo varible onto your To field

 

[madanthrax]

Neat code. Thanks a lot!

[sub]"Nothing is impossible until proven otherwise"[/sub]​