Worksheet button to send as attachment

E

erekhorne

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
 
T

Tim Whitley

Tie the following VBA code to a command button:

Private Sub CommandButton3_Click()
Application.Dialogs(xlDialogSendMail).Show
End Sub
 
5

525047

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
Click to expand...



Take a look at http://www.officefrustration.com/showthread.php?t=28389
which was the solution I was given some time ago
 
Top