Hi:

I have lots of files every day which needs to be emailed to client.
All these files are in C:\"To be Emailed"\
Currently I manually email each file thru Oulook 2010 and this takes lot of time and mistakes.

The structure of the file name which are in the above location :
Date_ClientName_Clientemailaddress
Example of file name : 07-27-2012_rizmomin_rizmomin@comcast.net
07-27-2012_JohnDoe_Jd@gmail.com


I would like to have a VB Script/Macro which will email all files and move the all the files to new location when done.

The body of the email should just say :

"Please find attached the file
Thank you
Riz Momin"

Please let me know if you have any questions.

Thanks

Riz