Worksheet button to send as attachment

  • Thread starter Thread starter erekhorne
  • Start date Start date
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
 
Tie the following VBA code to a command button:

Private Sub CommandButton3_Click()
Application.Dialogs(xlDialogSendMail).Show
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to use information in a cell to locate and send files using outlook 0
Sending a single worksheet as an attachment 3
Email individual worksheets?? 2
Email button??? 5
email button control 1
Access Automatically Send a notification email once a record is added 0
E-mailing the active worksheet 5
Outlook addin - how to tell an email is created from window explorer file->send to->mail recipient? 1

Back
Top