Hi,
I currently have names and emails in excel as below:

name email
1. John Smith john.smith@hotmail.com
2. Michael Black michael.black@gmail.com

How do I create a macro so that it creates a list of the emails in another cell?

E.g. the macro will create a string in cell H10 which reads "John Smith" <john.smith@hotmail.com>,"Michael Black"<michael.black@gmail.com>

many thanks!