Quote Originally Posted by RockPoint View Post
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