Hi Dave,
Yes each cell contains single email address.In a range,
the cells which are having email address should be hyperlinked.

Regards
Satish



On Dec 18, 10:47*pm, Dave Peterson wrote:
What does this mean?

I figured that a cell would contain a single email address. *So each cell would
require its own hyperlink.


Satish wrote:

Thanks for the reply, but can you help in writing a macro where i want
to do it for a range.

Regards
Satish

On Dec 18, 8:04 pm, Dave Peterson wrote:
If your data is in A1:A10 (say), you could add some formulas in B1:B10:

Put this in B1:
=hyperlink("mailto:" & a1,"Click to sendemail")
and drag down to B10

Satish wrote:

Hi
* *Can anyone help me in writing amacroon how tocreateemaillink
for theemailaddressesin aRangeorSelection.As i am new to excel i
am manually selecting each cell which is havingemailaddress , 'Press
F2' and then "Press ENTER".I want to automate the process and save the
precious time.