Email a screenshot of a specifc row in an email to a specfic email address

Hello, for starters, I am a novice. Not a beginner, but a novice. I dabble.

Ok, this might be a bit confusing, but here goes... I have a spreadsheet that I produce every two weeks for payroll to determine how much to pay my employees. I would like to send a screenshot of a single row (and a header) to each of my employees of their specific (and only their) commission and other pertinent information. The row of information that I send should only go to the email address in that row, since the information is private to each employee.

THis is what the table looks like:
screenshotttttt.jpg


I have the following piece of code (at the bottom) that I have used in the past to take a snapshot of a static couple of rows and open an email in outlook for me. But I dont know how to make that cut out dynamic (change based on who the email will go to). Also, I then must write the recipient in the to: field and then click send. This would work, but I would like to use just the header and the row of the respective email address. (meaning, I don't want Alexis to see information for anyone else...only her. and I don't want Sarah to see anyone elses information, only hers.) Also, I dont need to send to everyone, only a few of the employees, so, perhpas If I had a column that i put a checkbox in, or the letter "y" for yes and only send to those employees.

So an example ofthe end result that I am looking for is for me to do the following:
1.) put a "y" in column "O" for Alexis, Bianca and Shannon. (Row 2,4,5)
2.) Run a macro
3.) Have 3 emails generated (or automagically sent) as the following:
3a.) An email to [email protected] that says: Hello Alexis, here are your numbers for this pay period. And then paste the Header (A1:L1)and also the data (A2:L2)
3b.) A separate email to [email protected] that says: Hello Bianca, here are your numbers for this pay period. And then paste the Header (A1:L1)and also the data (A4:L4)
3c.) And another email to [email protected] that says: Hello Shannon, here are your numbers for this pay period. And then paste the Header (A1:L1)and also the data (A5:L5)

Here is what the email might look like:
Screen emails.jpg


And here is the code I used to make that email:

Please Login or Register  to view this content.

Any help is appreciated!!

updated code with code brackets. sorry :-(



And here is the code I used to make that email:

Please Login or Register  to view this content.

Any help is appreciated!!

Yee Haw!!!!

I wont suggest to use CDO since it requires many advanced configuration, but below code will nor require you to press send button & will remove "y" from column O too...

Please Login or Register  to view this content.

Cheers!!