Emailing From EXCEL

Hi All,
On to this weeks objective lol.

I've finished creating my file and would now like the user to email specific ranges etc from EXCEL. I have looked at various threads from Google and also this good site http://www.rondebruin.nl/sendmail.htm but none really do what I want. Some come close but as I don't understand VBA I can't edit them to achieve what I want. Besides, I'm sure someone on here knows a much easier way!

I've added a small file to try and explain what I want to do but basically once the user has finished entering information along a row of cells (Requirements Tab), I want them to be able to generate a 'list' that's then emailed. If possible, the user should be able to go down a column, putting "Yes" into the cell, then somehow the information from specific cells (not all cells) along that row is transferred to an email. The user should then be able to go to another part of the Requirements Tab and create another 'list' and email that to someone different.

The attachment explains it much better, I hope. If not I will try and answer any help replies best I can

Thanks in advance

PacE

Originally Posted by mudraker

Have a look at
http://www.rondebruin.nl/sendmail.htm

Tried that as stated in my first post but it's not quite what I'm after