I have a bit of a quandry. Large corporation with a few thousand users. Every user has their own login ID as a sub-folder on their server. We have a form filled excel file on the company intranet. Currently macro is set to send file as attachement once completed to specific e-mail address. The problem we are encountering is that when the recipient of the file receives the file and saves, they are running into issues with name after 100 entries. I am trying to adjust the macro to rename file prior to send. I would like it to rename the file based on the data entered in a specific cell. Having issues with the oldname as it will change for every user based on their login. Any help is greatly appreciated.