Post reply

DTS Absolute Path during "Send Mail" Task

  • June 11, 2004 at 6:13 am

    #59664

    I have a DTS job that attachs an Excel file from a network drive and emails it to external users.  The external users get the email, however it has the full path name.  How can I get the file to attach as "regular" ?

  • June 11, 2004 at 11:36 pm

    #510164

    You can add and activex scripts like this

    '**********************************************************************

    '  Visual Basic ActiveX Script

    '************************************************************************

     

    Function Main()

    Dim iMsg

     

    set iMsg = CreateObject("CDO.Message")

     

    Dim objMail   

    Set objMail = CreateObject("CDO.Message")

     

    objMail.From = "username@somewhere.com"

    'objMail.To ="jaimemaccou@colliergov.net"

    objMail.To ="one@somewhere.com,two@somewher.com"

    objMail.AddAttachment ("\\servername\driveletter$\folder\filename.xls")

    objMail.Subject="your subject here"

    objMail.TextBody = "Body Test here"

    objMail.Send

    Set objMail = nothing

     

    Main = DTSTaskExecResult_Success

    End Function

     

  • June 13, 2004 at 4:10 pm

    #510196

    That worked great.

    Thanks for the info.

Viewing 3 posts - 1 through 2 (of 2 total)

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