Macro to Email set of cells with identified email list and subject line with outlook

I am looking for some help with a macro to email the group of cells B2:K20 pasted in the body of the email via outlook.
I will have the email list identified N2:N15
The subject line will be cell O2

Email will be sent via outlook

Any help with making this macro would be greatly appreciated.

I have attached a blank file with the section identified that will be used for the email.

I have been working on it and the sent to list is not working
Here is the code so far and any help to make it better is greatly appreciated

Please Login or Register  to view this content.

Hi Aaron,

Try the following code which is included in the attached modified copy of your sample workbook.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

Thank you for your help