To send Mails using SQL

  • Hi,

    I want to send mail's from sql ,

    eg: Consider table as Table1 , with 1 column as modifiedon, When the modifiedon date is greated than 2 days of last modified date than mail has to be automatically sent to users.

    In google i read this can be done in SQLMAil,

    I have Exchange server's SMTP service for sending mails

    Can you please give me details steps to do this.

    Thanks in Advance,

    Archana

  • Isn't another topic next to yours just about that?

    _____________
    Code for TallyGenerator

  • yes, it was same , Just I started as new post .

    Its same problem.

  • hey Archana,

    Did u got any solution? for this i too need the same kind Mail to be sent.

    My Question:

    I need to check the last replicated Stores from DB and for this i have SQL query, but after finding the Result i need to send it to mail ID.

    Can you help me out.

    SERVER 2008 Studio.

    @JayMunnangi

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply