Well, this one was driving me nuts today at work so in case anybody else out there encounters it, here's the solution.
I was working on a sproc to add attachments to an email using CDO in SQL Server 2008. The command for this was easy enough.
EXEC sp_OAMethod @iMsg, 'AddAttachment', NULL...