Dump attachment / scan / format / send SQL 2000

[mutley1]

I realise this may be considered for the DTS section but I have done all that formatting etc. already, so here's why I opted for the programming section.

Inbound Excel, I convert, outbound file, I send.

Does anyone know if there is a way that when the mail comes in with an attachment, that i can strip the attachment into c:\something (then I can have the agent running every 2 mins to scan for the file), the DTS runss if it finds the file (it's renamed when it's finished with) then the difficult bit...I have SQL on my desktop machine, so no profile on here to set up mail with, go on, hit me with it.....no profile, no mail workee....???

1. Basically stuck on auto stripping file xyz_date if mail comes from person 123.
2. Sending it out when it's done from a desktop as an attachment via email because I can't get a mail profile on here (MAPI).

Thanks,

Matt.

 

[simian336]

I have used programs that will automaically print an email (but not the attachement).

But I have never seen one that would automatically save the attachment to a folder.

Good Luck

Simi

 

[simian336]

Is FTP and option?

Simi

 

[mutley1]

Never heard of FTP-ing to an email address. It needs to go to their mailboxes.

Thanks.