create a macro to send excel spreadsheet as attachment

Hi all
I have been trying to figure it out and I just cant do it...
I am trying to create a macro to send excel spreadsheet that I am working on as attachment to email adresses listed in the same spreadsheet.

The closest I got to find this was
http://support.microsoft.com/default.aspx?scid=kb;en-us;241498

There is one problem.. It doesnt send the spreadsheet =( it just sends a message to the people in the list.

HELP

 

There's a button on the tool bar that will do it.

 

naaa, but I meant, as if you were creating a form that when filled it would be sent to email addresses stored in a specific column

 

You can do it. You have to open a link to the Outlook application programmatically in VBA. For example, have a look at this Microsoft MSDN article.

However, if all you want is a form for users to submit information via e-mail, I'd look for an web solution. If users are on a local network, a PHP page on a central server is easy to set up.