E-mail confirmation...

Here is what I want to do:

Allow a user to fill in a form (name, address, a few personal questions etc.), store the data in an Access 97 database, send an e-mail to that person (BCC to another person as well) containg a thank you note and the very same data they entered on that form, which will be extracted from the DB (since the DB may have some other data that needs to be pulled into the E-mail).

Products I plan to use:

Microsoft Back Office 4.0 (IIS 4.0, IIS SMTP Server, ASP, Visual Basic, Visual InterDev etc.).

Any ideas/suggestions on where/how to start?
Who is Participating?
rajgnConnect With a Mentor Commented:
If you use IIS4.0, You can use NewMail Object in the built in  library CDONTS for mailing activities. It's very simple to use. You can build confirmation message based on the data the user enters(let's say 'mesg') then insert the following code to send it by mail.

  Set objNewMail = CreateObject("CDONTS.NewMail")
  objNewMail.Send("fromme@company.com", "toyou@company.com", "subject:Hello", _
                  mesg, 0) ' low importance
  Set objNewMail = Nothing ' canNOT reuse it for another message

Use Bcc,Cc etc. properties of this object to send Bcc or Cc. For complete documentation of this object, refer to:

loyaliserAuthor Commented:
Edited text of question
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.