Hey Guys, I've been working in an Email sender that must meet very specific criteria.

I was wondering if any of you could help me meet said criteria? First a bit of back ground. We have a procedure set up that generates a file on the clients end, and it gets sent to us via an SFTP. We then have to email these files to another company (Its the only way they'll accept them...) But we get 100's of these files in a day, we have to send them one by one, and we have to send them over a secure connection using outlook.

Basically, I need an email to open, select one file at a time from a directory of many files, attach it to the email, select the 2nd and 3rd character of the file name and place it in the subject (this is a site identifier), send the email over a secure connection.

I know I can create a script that can send an email over a secure connection as I've done it before in VB and in Python, but can you help with a script that also does the above?