Macro to email worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a VBA macro to e-mail a worksheet. Has anyone created
this and is willing to share?
 
If you are using Send in the Excel file menu, just do it with the macro
recorder on, it should give you what you want.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks for the reply. I have tried this with File>Send and with the e-mail
icon on the menu and neither one records. I think that when you go to these,
the application switches to Outlook, therefore the keystrokes are not being
recorded in Excel. I am hoping that someone had figured out a way to do this.
 
I tried the macro recorder on File>Send and the e-mail icon on the toolbar.
I think when you use these, the application switches to Outlook and is not
recorded in Excel.
 
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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Worksheet Names using Macros 5
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy worksheet from one workbook to a master workbook 2
Macro - edit with macro 4
Close all without saving and exit without prompts 8
Macro to make multiple copies of a formatted worksheet 1
Macro to get rid of #DIV/0! 2

Back
Top