Prev: diagnosing Service Broker problems - help
Next: Using ADOMD
From: gurbao on 13 Jan 2007 16:17
Hi,

I just migrated to 2005 from 2000 on which I had a job which generated
a html-file using sp_makewebtask and mailed it using sp_send_dbmail.
The file was not sent as an attachment but rather as the body.

I have activated Database Mail and want to send the generated file as
before, but have not figured out how to send it as body. Is this
possible?

I know I shourld rather use Reporting Services to do this in 2005, but
for now I would like to just send the file as before.

Regards,

From: Balt on 13 Jan 2007 17:52
Or use the really easy to use SMTP mailing options with CDOSYS? Let me know
if you need info on that.

"gurbao" wrote:

> Hi,
>
> I just migrated to 2005 from 2000 on which I had a job which generated
> a html-file using sp_makewebtask and mailed it using sp_send_dbmail.
> The file was not sent as an attachment but rather as the body.
>
> I have activated Database Mail and want to send the generated file as
> before, but have not figured out how to send it as body. Is this
> possible?
>
> I know I shourld rather use Reporting Services to do this in 2005, but
> for now I would like to just send the file as before.
>
> Regards,
>
>
From: gurbao on 16 Jan 2007 06:14

Well, then I might as well install the xp_send_dbmail on the new
instances.

Is this doable with the new Database Mail in 2005?

Regards,
On Jan 13, 11:52 pm, Balt <B...(a)discussions.microsoft.com> wrote:
> Or use the really easy to use SMTPmailing options with CDOSYS? Let me know
> if you need info on that.
>
>
>
> "gurbao" wrote:
> > Hi,
>
> > I just migrated to 2005 from 2000 on which I had a job which generated
> > ahtml-fileusing sp_makewebtask andmailed it using sp_send_dbmail.
> > Thefilewas not sent as an attachment but rather as the body.
>
> > I have activatedDatabaseMailand want to send the generatedfileas
> > before, but have not figured out how to send it as body. Is this
> > possible?
>
> > I know I shourld rather use Reporting Services to do this in 2005, but
> > for now I would like to just send thefileas before.
>
> > Regards,- Hide quoted text -- Show quoted text -

 | 
Pages: 1
Prev: diagnosing Service Broker problems - help
Next: Using ADOMD