Sending an Email with Excel File Using VB/ And help with Looping

[cnugent]

I have a file that I need to send to a group of individuals, however each person only sees certain parts of the file. I need help with two parts of this macro.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I created macros that will hide the sheets that aren't needed for the individuals so that when it is finished the only thing visible is what pertains to that individual. The one part of the macro I am missing is how to email it to this individual when the tweaking part of the macro is done. The email is based on a temporary tab containing their emails and based on how I set up the tweaking of the files it will always be in H2.<o></o>
<o></o>
The second part I am missing is a statement that says when the email is sent delete that person from the temp list and go back to the top of the script and do all the filters over again with the second person on the list. I know this is a loop, but I am unfamiliar with loops and heard they can be dangerous t create so I thought I'd ask. When the temporary tab of emails is empty (except for the header on top) I want the loop to stop.<o></o>
<o></o>
I'm sure to you experts this should be a breeze, but I don't know where to begin.<o></o>
<o></o>
Thanks in Advance for your help<o></o>
<o> </o>