send worksheet to mail recipient

[CurtisAC]

I'm sure this has be done (and likely posted) many times, but I can't find exactly what I'm after.

In Excel 2003, there is an option to send a worksheet to a mail recipient. How do I issue the following sequence: "Alt f", "d", "m", "b", cr to start this?

Thank you far any help you can provide.
Curtis

 

[Marc]

Check this site for useful methods to send excel via outlook.


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

 

[CurtisAC]

Thanks for the link. I'll check it out and see how it goes. For my education, is it possible to issue the commands throught a script or VB code?

 

[Smitty]

Welcome to the Board!

The link posted is for VBA solutions.

You can add a keyboard shortcut to code by going to Tools-->Macro-->Macros-->Select the macro in question-->Options. The shortcuts are preceeded by CTRL, just don't use anything reserved, like CTRL+C, CTRL+V, etc.

HTH,

Smitty

 

[CurtisAC]

One thing I have learned from all this...
Be clear in what you are asking.

The short story is, I would like a button that will cause the following key sequence to occur:

"Alt f", "d", "m", "b", cr

Looking back, I believe I neglected to give all the information for my challenge. I appologize for that.

Thanks for all your help.

 

[Smitty]

I would like a button that will cause the following key sequence to occur:

Check out SendKeys in the VB helpfile.

Although Ron's code will eliminate having to use that method.

You might also want to look at the SendMail method.

Smitty