Frontpage forms submitting to a database and email

Posted on 2009-02-13
Last Modified: 2012-05-06
Currently I have a ticket system where the user submits their problem and the page just dumps that data to an Access database. Then the confirmation page uses this code to send our IT staff an email notifying them that a ticket has been submitted:
dim msgbody
dim cdomail
set cdomail=createobject("cdonts.newmail")
While this seemed like a good idea, we all carry Blackberrys and it would be much nicer to have the information inputted in the form to come through the email that we are sent. Hence my question: Is there a way to make what I have work with added code or do I need to use a different method? Please keep in mind that I use FrontPage and the DRW to do my database transactions. I am by no means an html, asp or sql programmer. Thanks.
Question by:gwbmcse
    LVL 16

    Expert Comment

    Is this code not working for you now?
    LVL 15

    Accepted Solution

    Yes, you can modify that code to send the data in the email.

    Just modify the cdomail.body="" to include the form data.  

    All you would need to do is build a string that contains that data from the form.  I do not know what the form fields are, so here is a quick sample using "problem" and "notes"
    dim msgbody
    msgbody += "From: " & Request.Form("problem") & vbCrLf
    msgbody += "To: " & Request.Form("notes") & vbCrLf
    dim cdomail
    set cdomail=createobject("cdonts.newmail")
    cdomail.subject= "text"
    cdomail.body = msgbody

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
    I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now