Hi
Can anyone help me in writing a macro on how to create email link
for the email addresses in a Range or Selection.As i am new to excel i
am manually selecting each cell which is having email address , 'Press
F2' and then "Press ENTER".I want to automate the process and save the
precious time.

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 send email")
and drag down to B10

Satish wrote:

Hi
Can anyone help me in writing a macro on how to create email link
for the email addresses in a Range or Selection.As i am new to excel i
am manually selecting each cell which is having email address , 'Press
F2' and then "Press ENTER".I want to automate the process and save the
precious time.

--

Dave Peterson

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.

--

Dave Peterson

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.

--

Dave Peterson

--

Dave Peterson

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.

And how did it not work?

What was in the cell with the address (the exact text)?
What was the address of that cell?
What was the formula you used in the adjacent cell?
What was the address of the cell with the formula?



Satish wrote:

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.


--

Dave Peterson

Hi,
in another column enter

=HYPERLINK(D3&";")

Change D3 for the cell you have the email

"Satish" wrote:

Hi
Can anyone help me in writing a macro on how to create email link
for the email addresses in a Range or Selection.As i am new to excel i
am manually selecting each cell which is having email address , 'Press
F2' and then "Press ENTER".I want to automate the process and save the
precious time.
.