create email message from SQL and dump it in inetpub

Posted on 2006-05-03
Last Modified: 2010-04-17
I need to compose an email message with a csv file attachment and dump it to pickup folder of the inetpub. I couldn't use SQL xp_sendmail because there's no outlook in the server or other MAPI elements. Any idea how to do it in SQL? I already have a DTS which generate the csv the file and I need to send the file out through email?
Question by:sihua
    LVL 4

    Expert Comment

    You should be able to send the mail using SMTP, which I prefer to MAPI, anyway.  I do not have the code at my current location, but I should be able to send it along, tomorrow.
    LVL 19

    Expert Comment

    There are actions within DTS to send files to difeent detinations, icluding an email address. Don't have exact details, but online help should provide this.
    LVL 4

    Accepted Solution

    Here is a link to the source where I think that I learned about SMTP mailing with Visual Basic or VBA.
    LVL 2

    Assisted Solution

    try blat

    It is a really nice free command line mailer

    just reference from a stored procedure like this:

    exec master..xp_cmdshell @command

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Title # Comments Views Activity
    matchUp  challenge 6 35
    static class 3 44
    How to silent print from safari browser 6 97
    countClumps  challenge 10 68
    RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
    This is about my first experience with programming Arduino.
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now