Excel 2007 : Email Column C to Column A with Column B as subject

I just spent 2 hours wading through Ron's pages and the many many posts in this forum. I can't figure out how to simplify Ron's and tailor it to my needs which are simple. I just need to be able to send an email from excel with the following specs. Column A is the user names, Column B is the Subject, column C is the body, and each row should be a different email.
E.G.

ColumnA.................ColumnB.................ColumnC
auser.............size of your share...........Your share is this size. Too big.
buser.............size of your share...........Your share is this much smaller. thankyou
ETC...

I don't need filters or anything like that. I feel like this should be easy but we never covered this type of thing in my scripting class. Thanks for any help you can give. (Even if it is just a link to something I can use.) Oh and I am using Excel and Outlook 07, and all users are on network, so the actual email address shouldn't be needed.

Thanks again

I have added the code below as a module to my workbook but I can't figure out cow to add it. I create a button and try to assign a macro to it but it doesn't see the macro I created. Can anyone help me figure out what I am doing wrong? I can't even test this code to see if it will work. Thanks.

Please Login or Register  to view this content.

I've got it working except it keeps saying email ID not found.

Thanks for all your help. I got it to work. Here is my end code.

Please Login or Register  to view this content.