Linking to an email address

[wyndland]

Hi all,

I have a list of contacts in column B and their respective email address in column H.
In a (different) summary sheet (but in the same workbook) I would like to be able to click on a cell (which references the email) and to open the outlook email window.
I have read many ways of linking to hyperlinks but all seem irrelevant.
"Cannot open specified file" is the error I get when using this formula:
=HYPERLINK(INDEX(Database!$H$48:$H$170,MATCH($B$3,Database!$B$48:$B$170,0)))
It may be that its not possible what I want to do!

Many thanks in advance for your time

Glen

 

[Deepak]

Pls share the sample workbook....

 

[bobhc]

Good day wynland and welcome to the forum if you have not already done so, please read this link posted by Chandoo as it will help you in the use of the forum.

http://chandoo.org/forum/threads/new-users-please-read.294/


The way I have done it is to assign the hyperlink to a button, if it is just in a cell it will cover five of six cells or make the cell too wide on auto size.

On my system the hyperlink address is.....C:\Program Files\Microsoft Office 15\root\office15\OUTLOOK.EXE

And yes, this is for Excel 2013.


.

 

[Haseeb A]

Hello Glen,

For the emails must have "mailto:" after HYPERLINK.

=HYPERLINK("mailto:"&INDEX(Database!$H$48:$H$170,MATCH($B$3,Database!$B$48:$B$170,0)),"Click for Email")