Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    24

    Unanswered: How to send mail through SQL Server...

    Hi,

    I have a requirement of sending mail through SQL Server through SMTP port... But, I dont want to configure my database server as e-mail client...

    Is there any way to do it...

    Thanks in advance...

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    You can use the procedure xp_sendmail to send email. I'm not sure what you mean with 'client', but sqlserver won't take the place of outlook, pegasus mail or some other email client you have.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    For SQL Server to use xp_xxxmail it MUST be configured as a MAPI-complient client (as the poster noted). To avoid that you can use this:

    http://www.planet-source-code.com/vb...d=670&lngWId=5
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    I have also used vbSendMail from www.freevbcode.com with a lot of success. Again, you have to write a stored procedure to "wrap around" the DLL, but it works quite well.

    Regards,

    hmscott
    Have you hugged your backup today?

  5. #5
    Join Date
    Sep 2004
    Location
    Helsinki, Finland
    Posts
    45
    I would also go the CDOSYS way that rdjabarov suggests, then you don't need to worry about other things than the SQL part...

    Here is another link that might be worth checking out:
    http://support.microsoft.com/default...312839&sd=tech

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, its hassle-free than direct SQL Mail procedures.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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