Worksheet button to send as attachment
 

I would like to create a button on a worksheet that I have created to
allow users to send the worksheet they have just filled out to a
recipient via outlook. I know this can be done thru the File - Send
To - Mail Recipient (As Attachment), but I would like to make this as
easy as possible for the users. Can anyone help me out with the
code/macro needed to accomplish this?

Thanks

Worksheet button to send as attachment
 

If you make a reference to the Outlook 11.0 Object library, you will be
able to access the help pages which describe how do send e-mails with
Excel.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=534783