General discussion

  • Creator
    Topic
  • #2322876

    Builder.com: Send messages to a list of

    Locked

    by itmex@work ·

    I just tried the script provided in the newsletter, but SQL keep saying

    “Server: Msg 17963, Level 16, State 1, Line 0
    xp_sendmail: Procedure xp_sendmail expects parameter @recipients, which was not supplied.”

    What could be wrong? Obviously, it doesn’t like recipients inside a variable, but this was the whole point of the article…

    Thanks for your help!

All Comments

  • Author
    Replies
    • #3416942

      Send messages to a list of…

      by debate ·

      In reply to Builder.com: Send messages to a list of

      Ignacio,

      In the fourth and fifth lines of the SQL code, replace the brackets and their contents with a valid e-mail address.

      This is how the code appears in the mail (the brackets indicate that their contents should be replaced with a valid e-mail address):

      CREATE TABLE test_email
      (email_name VARCHAR(255) NOT NULL)
      GO
      INSERT test_email VALUES (‘‘)
      INSERT test_email VALUES (‘
      ‘)

      This is how the code should appear after you have replaced the contents of the brackets:

      CREATE TABLE test_email
      (email_name VARCHAR(255) NOT NULL)
      GO
      INSERT test_email VALUES (‘ignacio.hernandez@cwpanama.com’)
      INSERT test_email VALUES (‘ignacio.hernandez@cwpanama.com’)

      Please let me know if you continue to have problems with the code.

      Thank you

Viewing 0 reply threads