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.
 
Back
Top