Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Mailing from SQL using Exchange/Outlook forms

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-26 : 09:33:03
Gabor writes "Hi there,

I'm using W2K Adv Server SP2, SQLServer 2000 Enterprise Edition SP1 Outlook 2000, and Exchange Server 5.5

Is it possible to send out a formatted mail (ie. RTF or HTML) or use an Exchange/Outlook form, because the standard xp_sendmail produces a quit ugly look.

Other question:
Is it possible somehow to define a reply mail address other then the SQLServer it's own mailbox?

Out problem is that I have to send automatically offers to our customers and they require a nice look and feel. :-)

Thanx

Gabor"

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2001-11-26 : 09:58:47
Yes, Outlook allows for the designing of forms. If you want to use SQL Server, I suggest using CDONTS. CDONTS can be used via a stored procedure, and you can also control the reply address. There is an article or 2 here on SQL Team discussing this method, you should be able to find it by typing CDONTS in the search box.

*************************
Just trying to get things done

Edited by - royv on 11/26/2001 09:59:21
Go to Top of Page
   

- Advertisement -