Hello,
I had faced similar problems. I think if u look into the site it will
help you definitely. I will try later and come up with a direct
solution. For time being try the site and find out if it helped.
http://www.sqldev.net/xp/xpsmtp.htm
Cheers
RVG
j.******@rac.de (Jürgen Hetzel) wrote in message news:<ef**************************@posting.google. com>...
Hello!
My environment is: Win 2000 Server, MS SQL-Server 2000 (SP2)
and MS ExchangeServer 5.5
the two following TransactSQL-codepieces show different
results:
1. with attachment
master..xp_sendmail
@recipients = 'j.******@rac.de',
@subject = 'test',
@message = 'test',
-- ******************************
@attachments = 'c:\test.txt',
-- ******************************
@no_output = 'False'
-->18025 level 16 state 1 line 0
xp_sendmail failed with mail error 0x80004005
2. without attachment
master..xp_sendmail
@recipients = 'j.******@rac.de',
@subject = 'test',
@message = 'test',
-- ******************************
-- @attachments = 'c:\test.txt',
-- ******************************
@no_output = 'False'
-->Mail sent.
why am I not able to send emails with attachments?
Who can help me???
Thanks in advance
Jürgen