automaically generate e-mail from sql 2008 on record insertion

Posted on 2009-04-23
Last Modified: 2012-05-06
I have an infopath 2007 form where when filled out by an indiviidual, the data is sent to a sql server 2008 database.  This form has a field for the person to enter an e-mail address of which an e-mail needs to be sent to a different person letting them know that the the data has been entered in the database.  i'm not sure how to set up sql to take this e-mail address when a new record is created and send an e-mail to the intended recipient. perhaps someone could be of assistance.

i am using exhange 2007 as my e-mail server.
Question by:bwierwi
    LVL 60

    Accepted Solution

    you could put a trigger on the table and use database mail to send the is an article I wrote for db mail:

    Author Comment

    for some reason i am getting a "no connection could be made because the target machine is actively refusing it" error when attempting to send mail.  the ip address with port 25 associated with the error message is that of my smtp server.  port 25 is open.

    Author Comment

    figured it out. thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
    ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
    In this video we show how to create an Accepted Domain in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Ac…
    In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…

    761 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

    14 Experts available now in Live!

    Get 1:1 Help Now