I construct Email Aleart system to aleart the employee of new requestions placed in the database.
I try to revise this system, so as to use the " CDO.Message " instead of the " master..xp_sendmail " .
during my tests, I succeed to send the mail, but I face these problems :
1) I can't get the result set of the query to pass it to @body parameter.
2) I can't send the attachment (Company Logo) with the mail.
I try to revise this system, so as to use the " CDO.Message " instead of the " master..xp_sendmail " .
during my tests, I succeed to send the mail, but I face these problems :
1) I can't get the result set of the query to pass it to @body parameter.
2) I can't send the attachment (Company Logo) with the mail.
