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 -gt; Send
To -gt; 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
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: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=534783
- Jun 22 Fri 2007 20:38
Worksheet button to send as attachment
close
全站熱搜
留言列表
發表留言