Email and add to DB

Results 1 to 4 of 4

Thread: Email and add to DB

  1. #1
    NoMass Guest

    Default Email and add to DB

    I need to add the info from a form to a database and email it all to an address.<BR>Any ideas?

  2. #2
    Join Date
    Dec 1969

    Default RE: Email and add to DB

    If the database is MS/SQL Server you can use the xp_sendmail stored procedure to send the data by mail.

  3. #3
    Phill Miller Guest

    Default RE: Email and add to DB

    There are the CDONTS (collaboration data object) on IIS4.0 that will work. You have to have SMTP set up though. Here is the mail part, the DAtabase stuff is always the same<BR>Dim objCDO<BR> Set objCDO = Server.CreateObject("CDONTS.NewMail")<BR> <BR> objCDO.To = ""<BR> objCDO.From = ""<BR> objCDO.BodyFormat = 0 <BR> objCDO.MailFormat = 0 <BR> objCDO.Value("From") = "internet sender"<BR> objCDO.Value("Reply-To") = ""<BR> <BR> Dim SubjectLine<BR> SubjectLine = "ATN-" & Request.Form("SDesc")<BR> objCDO.Subject = SubjectLine<BR> objCDO.Body = emailBody &#039txtBody<BR> objCDO.Send<BR> <BR> Set objCDO = Nothing

  4. #4
    J Weber Guest

    Default RE: Email and add to DB

    Cool - thanks. How do I configure this to send the form values? Right now I&#039ve just got it sending blank email.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts