Macro to email worksheet

G

Globe Director

I would like to create a VBA macro to e-mail a worksheet. Has anyone created
this and is willing to share?
 
B

Bob Phillips

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)
 
G

Globe Director

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.
 
G

Globe Director

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