How do I create a macro button?

[Xander1]

I need to create a macro button to send my excel workbook in an email. Please help!

 

[Datsmart]

Good instructions here:
http://www.rondebruin.nl/sendmail.htm

 

[Xander1]

I've managed to get the button to appear, but I can't figure out how to tell it to email the workbook.

 

[Datsmart]

What code are you using?
Did you try any of the examples in the link I posted? If so, please post the code?
What email application are you using?

 

[Xander1]

I'm sorry, I've just never used macros before and I'm totally confused. I'm trying to send the email via Microsoft Outlook.

 

[Datsmart]

Here is a link for some good Basic Macro understanding:
http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm

 

[Smitty]

What's your e-mail client? If it's Outlook see: www.rondebruin.nl/sendmail

As for the button you can draw one from the Forms toolbar and assign a macro to it.

HTH,

Smitty

EDIT: Sorry John, I stepped into a meeting before posting and didn't see that you got it handled...