I am trying to design a spreadsheet where a user can click a macro button to
send the sheet to me. I was able to create the macro to send it, but the
sheet wasn't filled in. I'd like the macro to be able to save the file and
then send it without much hassle to the user. The saved file name can be
unique or can continually overwrite the existing one (but I wouldn't want any
dialogue boxes to appear). I've tried combining the macros for the save macro
and the sending email macro, but it doesn't work right (it will only send the
email, not save it). Any help is appreciated. Thanks!