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

Tie the following VBA code to a command button:

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

" wrote:

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

Wrote:
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



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


--
525047