I am using lookup to retrieve email addresses from another workbook.

When I simply type in an email address manually, it becomes a "hot" link,
where I just click on it, and it will open up a new email window in Outlook
with that email address in the to: field.

But when I use the lookup function, the email address doesn't work this way.
All that happens when I click on it is that I select that cell.

Any way I can have these turn back to hot links?

I've tried inserting a hyperlink, but that's more work than just copying and
pasting the email address into OL.