using macros in Outlook

[Roger]

I have Outlook 2003 and have written a macro that I use each week to
attached a data file to an email and send it to a client. I need to rename
the datafile before I send it, is there vba I can use to RENAME the file
from name.mdb to newname.mdb

thanks ... Roger

 

[F. H. Muffman]

I have Outlook 2003 and have written a macro that I use each week to
attached a data file to an email and send it to a client. I need to rename
the datafile before I send it, is there vba I can use to RENAME the file
from name.mdb to newname.mdb

A google of 'vba code rename file' turns up quite a few options.