Much too vague to do anything but guess at an answer.
One wild idea is a Task that launches Excel which in turn runs a stored
procedure to return the results set into excel. Another task could send the
email with attached file.
Could also run a process from the OS level , running the query output into
excel and then email it.
"TedJM" <te******@hotmail.com> wrote in message
news:55**************************@posting.google.c om...
I need to automatically generate via SQL, export to Excel and e-mailed
to other people montly. what should I setup in the sql server?