job email

hi
i'm new to sql administration.
the built in sp for email uses a single account to send email.
i have a table (fromEmail, fromName, toEmail, toName, subject,
content). the fromXXX fields are dynamic.
is there another sp that can send mail with these parameters?
how could i do this?
thanx
riyazwhat built in sp did you try?
sp_send_dbmail in sql server 2005 has a @.profile_name argument which is the
name of the profile to send the message from.
hth,
Cristian Babu
<rmanchu@.gmail.com> wrote in message
news:1147241986.934852.156770@.i40g2000cwc.googlegroups.com...
> hi
> i'm new to sql administration.
> the built in sp for email uses a single account to send email.
> i have a table (fromEmail, fromName, toEmail, toName, subject,
> content). the fromXXX fields are dynamic.
> is there another sp that can send mail with these parameters?
> how could i do this?
> thanx
> riyaz
>|||One that I use ,(it's not built in you will have to apply, straightforward)
is XPSMTP on .http://www.sqldev.net/xp/xpsmtp.htm
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
<rmanchu@.gmail.com> wrote in message
news:1147241986.934852.156770@.i40g2000cwc.googlegroups.com...
> hi
> i'm new to sql administration.
> the built in sp for email uses a single account to send email.
> i have a table (fromEmail, fromName, toEmail, toName, subject,
> content). the fromXXX fields are dynamic.
> is there another sp that can send mail with these parameters?
> how could i do this?
> thanx
> riyaz
>|||One that I use ,(it's not built in you will have to apply, straightforward)
is XPSMTP on .http://www.sqldev.net/xp/xpsmtp.htm
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
<rmanchu@.gmail.com> wrote in message
news:1147241986.934852.156770@.i40g2000cwc.googlegroups.com...
> hi
> i'm new to sql administration.
> the built in sp for email uses a single account to send email.
> i have a table (fromEmail, fromName, toEmail, toName, subject,
> content). the fromXXX fields are dynamic.
> is there another sp that can send mail with these parameters?
> how could i do this?
> thanx
> riyaz
>|||Jack Vamvas wrote:
> One that I use ,(it's not built in you will have to apply, straightforward
)
> is XPSMTP on .http://www.sqldev.net/xp/xpsmtp.htm
had a look. seems solid.
but how do i specify the name/email of the recipients? is this
possible? is there a format?
eg: John Doe <jdoe@.trademin.gov.mv>, Jane Doe <email>
thanx
riyaz