Send e-mail

I am trying to write a macro that sends an e-mail when the user presses a
button. As I understand it there is a built in e-mail function in Excel. I
have tried using the:

thisworkbook.sendmail(myemail@email.com, "Subject") but it does not work at
all.

How are you supposed to write this? I do not understand the recipients
argument..Please help me. Any help appreciated!!

Have a LOOK here
http://www.rondebruin.nl/sendmail.htm

many options

Corey....

"Arne Hegefors" <ArneHegefors@discussions.microsoft.com> wrote in message
news:8F17F038-D141-4BB8-AC45-8DCAC803C0C8@microsoft.com...
>I am trying to write a macro that sends an e-mail when the user presses a
> button. As I understand it there is a built in e-mail function in Excel. I
> have tried using the:
>
> thisworkbook.sendmail(myemail@email.com, "Subject") but it does not work
> at
> all.
>
> How are you supposed to write this? I do not understand the recipients
> argument..Please help me. Any help appreciated!!
>
>