send mail through sp_send_dbmail in sql 2005

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nilesh tayde
    New Member
    • Jul 2010
    • 4

    send mail through sp_send_dbmail in sql 2005

    Hi every body
    I want to send a simple HTML mail using DATABASE MAIL feature in SQL SERVER 2005.

    I've defined a public profile.
    I've enabled Database Mail stored procedures through the Surface Area Configuration .
    but I can't send a mail with sp_send_dbmail stored procedure in 'msdb' database .

    when I execute sp_send_dbmail in the Managment Studio the message is
    "Mail queued" but the mail is not sent.

    or give me step so that I configured sp_send_dbmail.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Try to send a test email from your SSMS window. See if you received that one first. Then try to send simple email with no HTML formatting, see if you got that one, too...

    Let's work from there...

    Good Luck!!!

    ~~ CK

    Comment

    Working...