E-mail Address Hyperlink & Cell Reference

[Barking_Mad]

Hi,

Iv'e got a helper column which produces an e-mail address in the cell A1 using the formula: =VLOOKUP(E9,A2:BI430,6,FALSE)

In another cell I have: =HYPERLINK(A1)

It produces a linked cell with the correct email, but when I click it I get the message: "Cannot Open The Specified File".

Can anyone help so the link opens in Outlook?

 

[Airfix9]

Try this:

=HYPERLINK("Mailto:"&A1)

 

[Barking_Mad]

Hi,

That works when I click on it, but oddly the cell text reads: mailto:xxx@yyy.com in it.

Can I hide the "mailto:" part?

 

[Airfix9]

Yep:

=HYPERLINK("Mailto:"&A1,A1)

You can do a lot more with HYPERLINK too. Have a look HERE

 

[Barking_Mad]

Hi,

Thanks that was just what I was looking for, once I got my head round the formatting

 

[Airfix9]

Welcome!