You have 200 addresses in A1:A200?

If yes, then maybe
=hyperlink("mailto:" & a1)
in B1 and drag it down.

Peter R wrote:

In excel, how do you make hyperkinks for 200 email addresses without
individual entries?

--

Dave Peterson