how to send each row by email

[RockPoint]

Thanks for the quick response. I've attached my file. Now what I need to do is use the name in column C in the "import" sheet to send an email to the corresponding email in column I in "sheet1". I only want to send an email to the people with column N of "import" < 5. The email should contain a message that says, "You have <value of column N> shares outstanding>.

I really appreciate the help.

[BARIS]

Thanks for the quick response. I've attached my file. Now what I need to do is use the name in column C in the "import" sheet to send an email to the corresponding email in column I in "sheet1". I only want to send an email to the people with column N of "import" < 5. The email should contain a message that says, "You have <value of column N> shares outstanding>.

I really appreciate the help.

Hi Rockpoint,
My file is similar to yours. Different sheets talk with others and then I organize them with Vlookup function. At last I put the code which posted by admin in below link. Then it works.
My advise is to edit your sheet structure in a different sheet and automatically move them to sheet 1, then run VBA. Mine works good with that way. In my understanding, we should learn the menthality of VBA code, then we can customize the code...

Regards
Baris

http://www.excelfox.com/forum/f2/how....html#post2190

[RockPoint]

Thanks for the help. How can I format the body of the email so that it can use specific cell values in the message?

For example, I want it to say

"Good Morning " (Cell B1)","
SKip a space <<<(Also, how do I code this?)
"You have a positions of "(cell N1)" shares."
Skip a Space
"Thank you"