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)
 CDOSYS Mail attachment

Author  Topic 

dotliz
Starting Member

1 Post

Posted - 2006-09-01 : 12:37:24
Hi

i am using the current command to send and attachment from a smtp sql procedure, it works nicely for txt attachments but it does not send the attach if it is any other format, like a tif,

this is the command line im using

EXEC sp_OAMethod @message, 'AddAttachment',null,@attachment

do u know if this works for tif or zip files?

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-09-01 : 13:12:24
Try adding this

EXEC sp_OASetProperty @message, 'MimeFormatted', False
Go to Top of Page
   

- Advertisement -