with no2, do you mean "how can I grab a record from the db and use it as the
subject line"?
If so , create the recordset , place the relevant values in some local
variables , and then add to the parameters when you create the xpSMTP
object",
If this is waht you mean I can post you an example.
--
Jack Vamvas
___________________________________
The latest IT jobs - www.ITjobfeed.com
<a href="http://www.itjobfeed.com">UK IT Jobs</a>
"sam" <s
@discussions.microsoft.com> wrote in message
news:5C154BDF-1B75-4E2D-A399-DF4BFB1644EB@microsoft.com...
> Hai, everyone here.
> i have set up the sql mail with xpSMTP. actually i can send the mail with
> successfully but i have a question here is :
> 1. SMTP can support sql query statement or not?
> 2. how i can get the results from my database as the message/subject for
> my
> mail?