Hello,

I have the following qustion.
I have a SQL table with fields

nr
name
email
assignment
partn
partq

There are several recs with code '010'and all the recs with this code have to be selected for the following. I would like to send an email to the person in the 'email' field with an attachment (text file) containing all the fields in this record.
Who can help?

Kind regards,

JM

Look into the system stored procedure: sp_send_cdosysmail it should do what you need.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

Thanks Dparsons for your reply,
As I am totally new to SQL Server my questions are
1. Where to find the system stored procedures
2. How to change these procedures so that they perform the desired task and how to save the procedures
3. How to execute these procedures

Thanks in advance

I wont walk you through the entire process as there are plenty of resources on the net dealing with the system stored procedures.

They are located in the master database and you do not have the abiltiy to change them or alter their functionality.

A basic call to the procedure would be something like
Exec sp_send_cdosysmail @fromAddress, @toAddress , @subject, @body

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========