Email from SQL server

[cc]

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

[MarkN]

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

[David Satz]

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