New-->Using DatePart and other Date Functions
(Updated) Using Single & DoubleQuotes in ASP with SQL Statements
(Updated) Emailing Form Results
Mass Emailing with CDO
Using The Ad Rotator
ASCII Character Set 0-127
Mass Emailing With CDO
Naturally, first you've got to make a connection to the Database and get a little SQL going:
Here, we set up the Body of the message - whatever you want, put it here and add vbcrlfs for formatting:
We're getting really close here - we instantiate the object that actually does the emailing. What I usually decide to do, is to put my own email address in as the main person to whom it's sent. That way, if I get it, I'm at least fairly certain that the mailing went through ok.
Now - here's where we put in all the rest of the names. Remember that variable we created from the loop above? Well, this is where it goes - at least for me, that is. With all the email addresses in the BCC section, it looks like they're all sent individually (at least theoretically).
Here's where you can simply do a response.write to insure yourself that 'MyVar' did indeed, make up all the email addresses you had thought it should:
We must tidy up a little:
One note of warning, though - - - before you do this, you should delete all email addresses going to Hotmail.com. For some reason, which I have yet to figure out, some emails going to Hotmail.com get in the hotmail system and replicate - 100s or even 1000s to the same email address.