Need help with emailing upon submission

ok, need email results of form email stored
in database. here how form works now...

currently have 1 field populated table contains
our store information. in table email address associated
store.

so want when complete form , select there store
the list. once submit form dumps data database ,
i want copy of submission emailed manager of
store..

currently use bit of code email upon submission, there anyway
to use , email results email contained in table?
or maybe there easier way accomplish task without
coding?


dim trixmail, trixbody

set trixmail = createobject("cdonts.newmail")

trixbody="first name: "& request.form("firstname") & vbcrlf
trixbody=trixbody & "last name: " & request.form("lastname") & vbcrlf
trixbody=trixbody & "e mail: "& request.form ("emailaddress") & vbcrlf
trixbody=trixbody & "po number: "& request.form ("ponum") & vbcrlf
trixbody=trixbody & "vendor name: "& request.form ("vendorname") & vbcrlf

trixmail.from="datechangerequest@mywork.com"
trixmail.to=request.form("emailaddress")
trixmail.cc="mflores@mywork.com"
trixmail.subject="your request has been submitted mss ,
processed"
trixmail.body=trixbody
trixmail.send
set trixmail=nothing

More discussions in Dreamweaver support forum

adobe