Post reply

Attachment using xp_sendmail

  • April 20, 2005 at 12:19 pm

    #61127

    Hi ,

    Could you please tell me the process where in i will be able to send an attachment using xp_sendmail.

    Thanks

    Suresh

     

  • April 20, 2005 at 12:51 pm

    #553886

    Search for "xp_sendmail" in books online and it will give you the list of parameters.  The @attachments parameter can be set to create an email attachment.

     

    Hope this helps!

  • April 21, 2005 at 9:29 am

    #554114

    Hi Guys,

    Thanks for the reply.

    I have tried all the ways.Even though i pass the parameter for the attachment the xp_sendmail procedure works well to send the mail,but without any attachement in that.So what are the things i need to consider if i need to send an attachment using this stored procedure.If you can brief about this i would be greatful

     

    Thanks

    Suresh

     

  • April 21, 2005 at 9:34 am

    #554117

    Sounds simple, but have you checked the path?  I just ran a quick test with the following syntax, and it seems to work fine.  Are you getting any errors?:

     

    exec master..xp_sendmail @recipients = 'bgates@microsoft.com', @subject = 'test', @attachments = '\\mypath\myfile.txt'

  • April 23, 2005 at 9:38 am

    #554478

    Hi Rookie,

    Thanks a lot for your help , i wasnt trying the way you said.Well the help menu of sqlserver is that reliable with no good examples on that.Well i will give it a shot.Could you please give me your hotmail id or yahoo id so that i can talk to you on much on datawarehousing.Thanks a lot again              

    Cheers!!!!!!

    Suresh

          

     

     

  • April 25, 2005 at 8:35 am

    #554605

    Hi ,

    I tried sending the mail with an attachment and it gave an error xp_sendmail failed with a mail error 0x80004005.

    But when i send the mail without an attachment it works well.

    Please let m know on this

    Thanks

    Suresh

     

  • April 25, 2005 at 8:57 am

    #554613

    I have had a similar message before.  I would try the following:

     

    xp_stopmail

    xp_startmail

     

    And see if that works.  If not, I would be interested to see if anyone else has experienced this mail error and what cause/solution they may have.

     

  • April 25, 2005 at 9:50 am

    #554636

    Hi Rookie,

    Do u mean to say that i need to begin with

    xp_stopmail

    xp_startmail

    and later the execute statement that you said

    Thanks

    Suresh

  • April 25, 2005 at 10:24 am

    #554648

    Hi Rookie,

    I dont have the permission to stop the procedure or start the procedure as i am working on the terminals that are setup in canada.Is there any other that you can think of to execute the process

    Thanks

    Suresh

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply