I also tried
EXEC sp_OAMethod @object, 'setHeader', 'subject', 'some subject'
well, I'm done playing for the night... Hey, I got the body to work :-) Who
needs to's, from's, and subjects anyways?!
hehe
g'night all - I'm taking off early.
Tom
----- Original Message -----
From: Howie Hamlin <[EMAIL PROTECTED]>
To: inFusion Support List <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2001 5:22 PM
Subject: Re: [iMS] imsMail COM Object in SQL7
> The return value from this call is undefined so you should ignore it.
>
> Regards,
>
> Howie
>
> ----- Original Message -----
> From: "Tom Langer" <[EMAIL PROTECTED]>
> To: "inFusion Support List" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 10, 2001 5:19 PM
> Subject: Re: [iMS] imsMail COM Object in SQL7
>
>
> > grr, I still say something isn't quite right...
> >
> > Here's some sample code from SQL Books on using a method with multiple
> > parameters:
> > -- Call a method.
> >
> > EXEC @hr = sp_OAMethod @object, 'Connect', NULL, 'my_server',
'my_login',
> > 'my_password'
> > IF @hr <> 0
> > BEGIN
> > EXEC sp_displayoaerrorinfo @object, @hr
> > RETURN
> > END
> >
> > Here's my example in my sp:
> >
> > EXEC @hr = sp_OAMethod @object, 'SetHeader', 'To', '[EMAIL PROTECTED]'
> >
> > The @hr value is -2147211483, which indicates it has failed. I'm trying
> to
> > call this the same way as the SendMail, except with additional
parameters.
> > The sendmail method I'm using in SQL is:
> >
> > EXEC @hr = sp_OAMethod @object, 'SendMail'
> >
> > And this works perfectly.
> >
> > Is there something else I'm missing here - I mean, there isn't much here
> :-/
> >
> > thanks again (more so for your patience!)
> >
> > Tom
> >
>
>
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.coolfusion.com/iMSSupport.cfm
> Need an iMS Developer license? Sign up for a free license here:
> http://www.coolfusion.com/iMSDevelopers.cfm
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
>
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
