Auto Mailer using Macro

I have a workbook, which has 5 different sheets - MASTER, east, west, north and south.

I wrote a macro which will store these sheets as a seperate file in a particular folder say c:\ccgl\mis

the file name would be something like east_ddmmyy_hhmm.xls.

Now the files are created. and these files have to be automatically sent to email ids say - east file to be sent to [email protected] and like. can this also be done? The query is that the file name changes everytime, on the basis of timestamp. (we are using lotus notes)


thanks in anticipation