Ok, now I found similiar, This one in fact came from Stardeveloper.com I had to modify to work - the others I found were close but it wouldnt let me email a specific "group" within my database. This does. The manner I came about this - Created a form on a page called sendemail.asp.
Have the following fields. fldRecipients - the Groups name fldSubject - self explanitory fldMessage - self Explanitory fldFrom - This I brought the value in as the logged-in session variable.
This page submits to sendemail2.asp This page displays everything you typed - and sends the email. When I created the recordset - I filtered by in my case Pilot_Level, with form variable of fldRecipients. This brought out only that group you wanted.
now sendemail.asp is a simple form entry page. Onto SendEmail2.asp all this goes above the <head> tags of course. and naturally you'll have to modify to fit your fields with your group stuff, smtp server, you get the point.
<% Dim rs__MMColParam rs__MMColParam = "1" if (Request.Form("fldRecipients") <> "") then rs__MMColParam = Request.Form("fldRecipients") %> <% ' Declaring variables Dim rs, mail, subject, message, data_source, sql_select, strImportance, no