create list in a message box from range

Hi Everyone

I want to show a message that will contain the names of people in a range that is updated regularly. I am using the following code:

Please Login or Register  to view this content.

The problem I have is , it will only show the person who's name is in cell D2. I have a named range (email2) which currently spans cells D2:D10, but as I said previously, the range can and will grow.

Does anyone have any suggestions?

Thank you once again RoyUK, it works perfectly!