General discussion

Locked

Builder.com: Send messages to a list of

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!

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Send messages to a list of...

by debate In reply to Builder.com: Send message ...

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 ('<my email address>')
INSERT test_email VALUES ('<my alternative email address>')

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

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums