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!

Think this link should help you

http://www.rondebruin.nl/mail/add-in.htm

VBA Noo

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56213

Ron's site is the definitive reference for sending e-mails. Give it a look. I
am sure what you want is in there.

http://www.rondebruin.nl/sendmail.htm
--
HTH...

Jim Thomlinson


"SAS" wrote:

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!