Attachments with database mail

HEllo,
is it posible to have, the attachments of mail as body.
It is possible with xp_smtp_sendmail(@.messagefile parameter).
I don't find the same with sp_send_dbmail
Thank you.
Ad@.attach_query_result_as_file ?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<aurelien.decamps@.gmail.com> wrote in message
news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
> HEllo,
> is it posible to have, the attachments of mail as body.
> It is possible with xp_smtp_sendmail(@.messagefile parameter).
> I don't find the same with sp_send_dbmail
>
> Thank you.
> Ad|||Wasn't clear, but I *think* the op wanted an HTML file to be implanted as
the body.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:1CEEF022-D482-4D4D-86E5-5344E33B32C6@.microsoft.com...
> @.attach_query_result_as_file ?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> <aurelien.decamps@.gmail.com> wrote in message
> news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
>> HEllo,
>> is it posible to have, the attachments of mail as body.
>> It is possible with xp_smtp_sendmail(@.messagefile parameter).
>> I don't find the same with sp_send_dbmail
>>
>> Thank you.
>> Ad
>|||Ah, OK, I didn't get that... Hmm, I can't see a way to attach a file and make it the body of the
e-mail. I haven't tried various permutations of params to do just that, though...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eXJILMXqIHA.4112@.TK2MSFTNGP03.phx.gbl...
> Wasn't clear, but I *think* the op wanted an HTML file to be implanted as the body.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:1CEEF022-D482-4D4D-86E5-5344E33B32C6@.microsoft.com...
>> @.attach_query_result_as_file ?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> <aurelien.decamps@.gmail.com> wrote in message
>> news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
>> HEllo,
>> is it posible to have, the attachments of mail as body.
>> It is possible with xp_smtp_sendmail(@.messagefile parameter).
>> I don't find the same with sp_send_dbmail
>>
>> Thank you.
>> Ad
>|||Hi
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/03/28/send-table-or-view-as-embedded-html-lt-table-gt-in-an-email-stored-procedure.aspx
<aurelien.decamps@.gmail.com> wrote in message
news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
> HEllo,
> is it posible to have, the attachments of mail as body.
> It is possible with xp_smtp_sendmail(@.messagefile parameter).
> I don't find the same with sp_send_dbmail
>
> Thank you.
> Ad|||Hello, thank you for your answer, but it's true that the problem is
not clear :).
I want to have the contents of a text file in the body of the email.
like @.messagefile parameter of the xp_smtp_sendmail proc
On 29 avr, 09:42, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hihttp://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/03/28/send-ta...=
> <aurelien.deca...@.gmail.com> wrote in message
> news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
>
> > HEllo,
> > is it posible to have, the attachments of mail as body.
> > It is possible with xp_smtp_sendmail(@.messagefile parameter).
> > I don't find the same with sp_send_dbmail
> > Thank you.
> > Ad- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -