Thanks for pointing me in the right direction, Phil! Go Wallabies! That totally did the trick.

For those of you with the same problem, it basically goes like this...

/* new...

I would try that but it's not my server. I don't have access to install new DLLs so I have to work with the tools at hand.

I am under the...

I am having the same problem. The relevant SQL is thus:

EXEC @r = sp_OAMethod @MailID, 'Attachfile', @FileName

My return value @r is -2147211483. I haven't found this...

hmmm... I guess that would work. I was hoping for something a bit smoother but it is an overnight process so I could run some procedures twice.

I would have...