We are producing an Excel spreadsheet using SYS(3) for our file naming convention. When I attach this file to an email via VBA is there a way to rename the attachment. For example, I am attaching file 73842324.XLS and want to call it NBLMUsage121598.XLS when it is attached.

Obviously this is a multi-user issue; that's why we are using SYS(3). We cannot risk renaming the file on the hard disk in a multi-user environment.

Thanks, Bob