software

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?

ThanksTie the following VBA code to a command button:

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

quot; wrote:

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

Wrote:
gt; I would like to create a button on a worksheet that I have created to
gt; allow users to send the worksheet they have just filled out to a
gt; recipient via outlook. I know this can be done thru the File - Send
gt; To - Mail Recipient (As Attachment), but I would like to make this as
gt; easy as possible for the users. Can anyone help me out with the
gt; code/macro needed to accomplish this?
gt;
gt; Thanks
Take a look at www.officefrustration.com/sho...d.php?t=283896
which was the solution I was given some time ago.--
525047