Results 1 to 2 of 2

Thread: SQLMAIL

  1. #1
    Devendra Rane Guest

    SQLMAIL

    I have installed MS exchange client on my NT 4.0 server.
    and installed SQL server 6.5 on same.I have marked MSSQL server service as log on as service and also map correct profile in exchange.I am able to start
    sql mail service but when i am trying to send a mail by xp_sendmail i am getting error:
    Msg 17914,level 18,state 1
    Unknown recipient: Parameter `@recipients`,recipient `devendrar`.

    where `devendrar` is profile name

    and what i am trying to do is :
    xp_sendmail `devendrar`,`msg to send`

    can u pls help me to solve this problem.


    Devendra Rane.

  2. #2
    Fábio R. Póvoa Guest

    SQLMAIL (reply)

    Devendra,

    Try and use yur complete email address instead of the profile. Your statement would look like :

    xp_sendmail `devendrar@nsdl.co.in`, `Hello, world :-)`

    Hope this helps,

    Fábio

    On 7/30/98 1:38:36 AM, Devendra Rane wrote:
    > I have installed MS exchange client on my NT 4.0 server.
    and installed SQL
    > server 6.5 on same.I have marked MSSQL server service as log on as service
    > and also map correct profile in exchange.I am able to start
    sql mail
    > service but when i am trying to send a mail by xp_sendmail i am getting
    > error:
    Msg 17914,level 18,state 1
    Unknown recipient: Parameter
    > `@recipients`,recipient `devendrar`.

    where `devendrar` is profile
    > name

    and what i am trying to do is :
    xp_sendmail `devendrar`,`msg to
    > send`

    can u pls help me to solve this problem.


    Devendra Rane.

Posting Permissions

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