I have Outlook 2003 and have written a macro that I use to
attach 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. It there a www site where I can get a list of
the vba commands that can be used ?

thanks ... Roger

Renaming a file can't be done in VBA AFAIK, but you can use the Microsoft
Scripting Runtime library See the File.Name property.

BTW, you can download the Outlook VBA help file he

Download details: Office 2003 Editions: Outlook VBA Language Reference:
http://www.microsoft.com/downloads/d...DisplayLang=en

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Roger" wrote:

I have Outlook 2003 and have written a macro that I use to
attach 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. It there a www site where I can get a list of
the vba commands that can be used ?

thanks ... Roger