Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How can I send Excel attachment by using xp_sendmail?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-04-03 : 07:22:11
Hüseyin writes "Hi everybody,

I have got Excell file.
I am trying to send it by using xp_sendmail.
But I couldn't manage to send it.

HOw can I send an Excel File with xp_sendmail or whatever one in SQL server 2000?

Is there any way to send it in SQL server?

Thanks for your attention.

Best regards."

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-04-03 : 07:45:30
HTH..
exec master..xp_sendmail
@recipients='xx@zz.com',
@message='Test Mail Plz Ignore this',
@subject='Test Mail',
@attachments='c:\new.log'

Refer BOL for more options..



Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-04-03 : 12:43:03
You can send any file as an attachment as long as the server can get to the file. Just remember that xp_sendmail runs on the server and not on your machine.

What is the error that you are getting?

Tara
Go to Top of Page
   

- Advertisement -