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
 Transact-SQL (2000)
 SQL Mail & Attachments

Author  Topic 

Ste_Donkin
Starting Member

6 Posts

Posted - 2003-12-19 : 05:16:45

Hi All, I am wondering if someone can help a total newcomer out.
I am going to receive a daily email from a client in Excel format and I want to get SQL to automatically save the attachment to a designated folder. The attachment doesn't need to be opened, just saved.
How do I get sql to identify which attachments it needs to save? By sender? file extension? or a combination of both?
I have been reading a bit about xp_readmail and sp_processmail but it is not sinking in at all.

Has anyone who may have done this before got any suggestions about how to go about it?
   

- Advertisement -