Match the file name and send the mails

Hi,

i have a requirement in outlook. want ur help to automate one big manual process.
Ok, let me explain. I have a folder which contains some ASCII files(machine generated) but file name is in Alphanumerical foramat (eg: Abh2031). now i want to send this file to one email id that also contains the same alphanumeric format (eg: bng.abh2031@in.com). I want to do this as a automation process. when i run that tool it should pick the file and attach it to outlook and search for the email id and pick the email id which has same alphanumeric code and send the mail to that address. I have a list of email ids in a excel sheet also.
can any one help me to create a automated tool with any language.

I need to send around 500 mails every day.. i wanted to do this as a automation.


Appreciate the quick response.

Let me know, if u need any additional info....

Thanks !

Warm regards, :thumb
Discover.

Is the email address always: bng.<alphanumeric string from file name>@in.com?

Hi,

Thanks for ur reply.. no it is not similar always.. it might change, but the filename is a part of email id.

warm regards,
Discover