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.
Bookmarks