Sending Mail, Body message from database

chlad · August 12th, 2006, 01:11 PM

hi everyone!

i have to send a mail using asp wherein in Body part some of the data will be retrieved from the database.
how will i retrieved all records for example it has 5 records per person?

do i have to put the ff:

Mail.Body = do while not rs.eof...
Mail.Body = Mail.Body & .....

Mail.Send

----------------

please help.

thanks.

elopus · August 16th, 2006, 10:34 AM

If you've got 5 records for person, I'd think you'd need one loop for each person, then a further loop inside that for each record. For example, in pseudocode:

Code:

while not Users.EOF
    Mail.To = Users("email")
    Mail.Body = "Message start..."
 
    while not Users_Records.EOF
        Mail.Body += "Record " + Users_Records("Record_Details")
    end while
 
    Mail.Send
end while

Make any sense?

Regards,
-Mark
View my web development blog

chlad · August 28th, 2006, 12:54 AM

hi elopus!

i tried but it didn't work.

i can generate data and show it in a page in a table format. but my problem is in sending via email wherein it will loop on the entire recordset.

any other idea on how can i make this?

thanks a lot. i appreciate your help.

nothingwrongtotryme · November 16th, 2006, 01:05 AM

why do you write the do while stuff in the message body ??? create a record set with the filters u require, and then only dump the recordset field in the body value thats it. It works like a charm.