Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Send Email 1

Status
Not open for further replies.
niall29

niall29

Technical User
May 1, 2003
38
GB
Hi This is something that I have never done before so please be patient.....

I am trying to get Sql Server 2000 to run a SP on the 1st day of the month which will email the results from last month to a Email list.
I have the SP built and tried to create a job to send the Eamil using XP_SendMail but Im not doing something right and it keeps failing giving the Error saying message service is not running

Please can any one help..
Thnaks
 
Sort by date Sort by votes
You'll need to install and configure Outlook to use xp_SendMail. There is some info here faq962-4452. Let me know if you have any questions.

Denny

--Anything is possible. All it takes is a little research. (Me)

[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Email Alert on Status change 1
Replies
13
Views
406
bborissov
bborissov
dvannoy
  • Locked
  • Question
html sql email and body formatting 1
Replies
2
Views
151
dvannoy
dvannoy
junkmail
  • Locked
  • Question
dbmail email issue all of a sudden
Replies
2
Views
133
junkmail
junkmail
nice95gle
  • Locked
  • Question
Email and CSS in T-SQL 1
Replies
3
Views
272
jbenson001
jbenson001
kjv1611
  • Locked
  • Question
SPLIT() Function in SQL to Send values to a Table along with ID from within SELECT Statement? 1
Replies
4
Views
208
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top