B
bsharp
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.
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.