MS SQL - how to change header in mail

microsoft.public.sqlserver.programming

21 Jul 2006 11:19 AM

Chris

hi,
I have ms sql server 2000. I need to send automatic emails from it. I am using:
exec sp_OACreate 'CDO.Message', @iMsg OUT;
---- so on---
the properties of the object are set up by:
sp_OASetProperty @iMsg, 'To', @variable -- that is an example

buy I really need to modify the mail header. especially content type and encoding. is it possible? What properties need to be changed?
thx in advance From http://www.developmentnow.com/g/113_0_0_0_0_0/sql-server-programming.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com

26 Jul 2006 8:43 AM

Chris

HELP!!!! Plz

anyone can tell me what properties to set up are available for CDO object
(by using sp_OASetProperty) ?