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)

"Globe Director" wrote in message
...
I would like to create a VBA macro to e-mail a worksheet. Has anyone
created
this and is willing to share?

Thanks for the reply. I have tried this with FileSend 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.

"Bob Phillips" wrote:

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)

"Globe Director" wrote in message
...
I would like to create a VBA macro to e-mail a worksheet. Has anyone
created
this and is willing to share?

I tried the macro recorder on FileSend 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.

"Bob Phillips" wrote:

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)

"Globe Director" wrote in message
...
I would like to create a VBA macro to e-mail a worksheet. Has anyone
created
this and is willing to share?

Maybe you should have a look at this:
http://www.rondebruin.nl/sendmail.htm


--
RyGuy


"Globe Director" wrote:

I tried the macro recorder on FileSend 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.

"Bob Phillips" wrote:

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)

"Globe Director" wrote in message
...
I would like to create a VBA macro to e-mail a worksheet. Has anyone
created
this and is willing to share?

See Ron de Bruin's site for code and his SendMail add-in.

http://www.rondebruin.nl/sendmail.htm


Gord Dibben MS Excel MVP

On Thu, 1 Nov 2007 06:48:02 -0700, Globe Director
wrote:

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