Email from SQL server


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Email from SQL server

  1. #1
    cc Guest

    Email from SQL server


    Hi all,

    I am working on an email generation process. So far I have got the product
    working to the point where I have the emails text inside a SQL Server database.
    I want to take the emails which are held in a database temporary table straight
    from SQL Server to an email server. I can't use SQL Mail as the message
    size is limited to 8000 bytes for that and lots of my email messages are
    larger than that. What I am thinking is that maybe I can talk from SQL to
    the mail server using SMTP and forward all the emails on that way. Or perhaps
    to write a VB dll which "talks" to the mail server and forwards all the emails
    on. ANyway, I'm looking for ideas about how people think I could approach
    this.

    TIA
    CC

  2. #2
    MarkN Guest

    Re: Email from SQL server


    How are the messages getting into the temp table?

    I would write the messages to a MSMQ queque (instead of a temp table) and
    have that queue kick off a process to send the email messages. Either way,
    I would have an (VB) app do the retrieve and send work.

    Mark

    "cc" <cc@somewhere.com> wrote:
    >
    >Hi all,
    >
    >I am working on an email generation process. So far I have got the product
    >working to the point where I have the emails text inside a SQL Server database.
    > I want to take the emails which are held in a database temporary table

    straight
    >from SQL Server to an email server. I can't use SQL Mail as the message
    >size is limited to 8000 bytes for that and lots of my email messages are
    >larger than that. What I am thinking is that maybe I can talk from SQL

    to
    >the mail server using SMTP and forward all the emails on that way. Or perhaps
    >to write a VB dll which "talks" to the mail server and forwards all the

    emails
    >on. ANyway, I'm looking for ideas about how people think I could approach
    >this.
    >
    >TIA
    >CC



  3. #3
    David Satz Guest

    Re: Email from SQL server

    obviously this approach may not be for you, but we use Cold Fusion (CFMail)
    and it is a snap to query databases and then send the results however you
    like via CFMail.
    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions
    { SQL Server 2000 SP2/6.5 SP5a } { Cold Fusion 5 SP1 } { VSS }
    (Please reply to group only - emails answered rarely)
    -----------------------------------------------------------------
    "cc" <cc@somewhere.com> wrote in message news:3ceb0b5e$1@10.1.10.29...
    >
    > Hi all,
    >
    > I am working on an email generation process. So far I have got the

    product
    > working to the point where I have the emails text inside a SQL Server

    database.
    > I want to take the emails which are held in a database temporary table

    straight
    > from SQL Server to an email server. I can't use SQL Mail as the message
    > size is limited to 8000 bytes for that and lots of my email messages are
    > larger than that. What I am thinking is that maybe I can talk from SQL to
    > the mail server using SMTP and forward all the emails on that way. Or

    perhaps
    > to write a VB dll which "talks" to the mail server and forwards all the

    emails
    > on. ANyway, I'm looking for ideas about how people think I could approach
    > this.
    >
    > TIA
    > CC




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center