Home All Groups Group Topic Archive Search About

xp_SendMail subject blank problem

Author
20 May 2006 10:10 AM
Sayem
Hi,
while sending mail through xp_sendmail the mail is sending properly.
but subject getting lost while viewing the mail from outlook.
can anyone help me.

code:
EXEC xp_sendmail @recipients = 'con***@maersk.com',
   @message = 'The master database is full.',
   @copy_recipients = 'mah***@maersk.com',
   @subject = 'Master Database Status'

Can anybody help me? Plz am trying to solve this for 1 n half months.

Author
20 May 2006 1:25 PM
Aaron Bertrand [SQL Server MVP]
Could you try with a different component (e.g. xp_smtp_sendmail, see
http://www.aspfaq.com/2403 )... this component is a lot less hassle than SQL
Mail, and at the very least will tell you if the problem is coming from SQL
Mail or from your Outlook client.




Show quote
"Sayem" <saye***@gmail.com> wrote in message
news:1148119823.721822.299330@i40g2000cwc.googlegroups.com...
> Hi,
> while sending mail through xp_sendmail the mail is sending properly.
> but subject getting lost while viewing the mail from outlook.
> can anyone help me.
>
> code:
> EXEC xp_sendmail @recipients = 'con***@maersk.com',
>   @message = 'The master database is full.',
>   @copy_recipients = 'mah***@maersk.com',
>   @subject = 'Master Database Status'
>
> Can anybody help me? Plz am trying to solve this for 1 n half months.
>
Author
21 May 2006 4:50 AM
Sayem
thanks for ur reply. i have installed the xp_smtp_sendmail dll. but its
returns failure. i think it's because of my exchange server
authentication problem. how can i send a authenticate mail through this
dll.
Author
21 May 2006 10:19 AM
Aaron Bertrand [SQL Server MVP]
Why do you need to use Exchange?  Any Windows server with IIS installed can
send mail via SMTP.



Show quote
"Sayem" <saye***@gmail.com> wrote in message
news:1148187027.668427.294120@u72g2000cwu.googlegroups.com...
> thanks for ur reply. i have installed the xp_smtp_sendmail dll. but its
> returns failure. i think it's because of my exchange server
> authentication problem. how can i send a authenticate mail through this
> dll.
>
Author
23 May 2006 3:17 AM
Sayem
but i don't know how to configure IIS to send mail. Could you please
tell me.
Author
23 May 2006 10:41 AM
Aaron Bertrand [SQL Server MVP]
Google is your friend.
http://www.windowsitpro.com/Web/Article/ArticleID/23811/23811.html


Show quote
"Sayem" <saye***@gmail.com> wrote in message
news:1148354238.815063.118200@g10g2000cwb.googlegroups.com...
> but i don't know how to configure IIS to send mail. Could you please
> tell me.
>

AddThis Social Bookmark Button