Opening multiple Concatenate hyperlinks

[Tony_Coe1]

I have data in in cells shown, i can open the hyperlink but i have many of them in a column and wondered if there was a way of opening them all at the same time with one click or using macros.

=HYPERLINK(CONCATENATE("mailto:",A5,"?subject=",B5,"&body=",C5),"Send e-mail")

Also i have data in one column and would like to enter "Dear" infront of all the cells in the column.

Is there a way to do either of these please. Any help would be appreciated.

Thanks

Tony

[dilipandey]

Hi Tony,

Welcome to the forum.

For second part, you can have "Dear" concatenated with that column data in a new column... for first part..we can have loops or anyother thing, suggest you to upload the sample file. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>