Software

Ask something
Discussion Locked

Builder.com: Send messages to a list of

0 helpful
1 reply

by Member 26426508

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

1 reply

by debate

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

This discussion is closed to new replies.