Concentrate email address with selection

Hello all,

Hope someone can help.
In the attached i have names in column A and in B the person can choose either
yes/no.
If they choose yes then their name is copied to sheet2 when they press the make selection button.
What i need help with is i would like the company email address (@companyname.com) to concentrate to what ever names are copied in sheet2.

Thanks in advance.

Hi mdshotgun
working with your code try....

Please Login or Register  to view this content.