Emailing From EXCEL

[PacE]

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

[mudraker]

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

[PacE]

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

[VBA Noob]

The below link should get you started.

Add this code to filter on say col R (18) to a new sheet. Then turn on the record and delete the unwanted columns.

Then you can use the code from Ron site to e-mail the new sheet

http://www.rondebruin.nl/copy5.htm

VBA Noob