send worksheet to mail recipient

CurtisAC

New Member
Joined
Sep 29, 2006
Messages
7
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
:confused:
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

CurtisAC

New Member
Joined
Sep 29, 2006
Messages
7
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

Legend
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Sep 29, 2006
Messages
7
One thing I have learned from all this...
Be clear in what you are asking. :oops:

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

Legend
Joined
May 15, 2003
Messages
29,536
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
 

Forum statistics

Threads
1,140,917
Messages
5,703,168
Members
421,279
Latest member
emzy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top