I am using Excel 2007. I have a list of names in column A and email
addresses in column B. I want to create a macro or something that will allow
me to click on a hyperlink (or button) and it puts all the email addresses
into on email so i can do a mass email. I will be adding names to the list
so I want it to update it everytime you click on it.

ALso can you click on it and it asks what names you want the email to go to?