February 4, 2008 at 8:45 am
I'm creating a proc to send an email. Everything works fine (I get the email) until I try and add an attachment. When I add the attachment I get:
"xp_sendmail: failed with mail error 0x80004005"
begin
select @email_recipients = 'user@address.com'
select @email_subject = 'Test Subject'
select @msg = 'Test Msg'
exec Server.master.dbo.xp_sendmail @recipients = @email_recipients,
--@attachments = 'C:\filename.pdf',
@attachments = 'C:\filename.txt',
@subject = @email_subject,
@message = @msg
end
I know my filenames arew correct
February 4, 2008 at 10:36 am
Are they correct on the server or your workstation?
It needs to be on the server.
February 4, 2008 at 10:38 am
I moved the files out to the server and it works now.
Thank you
February 4, 2008 at 10:51 am
check if there is any program like AV tat is blocking you to send attachments from slq server.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply