I am trying to send data from a database displayed with a form via an email. The database connection is to an MSAccess database.
default.asp - user selects a location and is redirected to
EligibleOrNot.asp. Based on a check in the database, the use is either redirected to:
NotEligible.asp (message displayed with guidelines) OR
Eligible.asp. In addition to the form fields, the user is given some information stored in the database (tblWeb.SSLink) and (tblStaffDirectory.SDFName
. Once the form is complete, the user clicks the submit button. The form data is transferred to Eligible2.asp. The form data is sent to a database AND sent via an email. I have this functioning correctly.
I now need to send the database data (tblStaffDirectory.SDFName
included in the email.