Creation of bulk Mailto hyperlinks

Dear listmates,

I would like to start off with apologizing for the newbie post. I need some assistance in writing a macro that will enable me to create mailto links in any particularly selected columns.

I have excel ss that have plain text email addresses in one colume, in hundreds of rows. If I could write a macro that would simply create mailto hyperlinks in the selected column that would help me avoid manually creating for each email address.

Thanks a bunch in advance.

Jay