I want to do a save as macro that will prompt the user to designate the file
location and enter their own personalized file name. Then once they click
okay to save, I want to be able to complete the macro by emailing it out.

Help!