| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to send excel file as an attachment with OE instead of Outloo | New Users to Excel | |||
| How do I send an Excel attachment so that the recipient cannot al. | Excel Discussion (Misc queries) | |||
| Why is "send to mail recipient as attachment" greyed out in excel | Excel Discussion (Misc queries) | |||
| How do I add a command button on a worksheet to "paste" from the . | Excel Worksheet Functions | |||
| Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Hybrid Mode
