If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Combine Emails From Column Into Single Cell Separated By Comma, Renamed, Hyperlinked

Thread starter kimber7
Start date Aug 3, 2011
Tags

combine emails hyperlink function

kimber7

New Member

Aug 3, 2011

I have a worksheet with a column of email address. I would like to combine those email address (excluding the title in first cell) into a different cell on the same sheet and have them separated by a comma. Then, rather than seeing all of the emails, I would like to say a nickname such as "X_Customers". I would like to have hyperlinked so that I just have to click on "X_Customers" and have it open my email and be able to email all of those customers without them being able to see all of the emails I am sending to. I hope that makes sense! Any help would be greatly appreciated!!