I have created a macro that sends a file via email. Within the macro, i have
it copy into a new workbook, then save the file, then email the file. Can
you write a macro that enables the person sending the file to name the file
themselves? Currently i have it titled "NEW" in the macro, but every time
the send a new one, it asks if you want to override the previous one.

I hope this all makes sense. Plus i hope there is a solution. Thanks for
any help you can be.