How do I prevent a blank email form being generated when I click in a cell that happens to contain a

  • Thread starter Musawwir Spiegel
  • Start date
M

Musawwir Spiegel

I am running Excel 2007 on a Windows 7 computer

I have a worksheet in which two columns contain email addresses which
I want to compare. Every time I click on a cell containing an email
address my Outlook program generates a blank email with the address in
the clicked cell as its address.

How do I stop that from happening?

Musawwir Spiegel
(e-mail address removed)
 
T

Trekman

I am running Excel 2007 on a Windows 7 computer

I have a worksheet in which two columns contain email addresses which
I want to compare.  Every time I click on a cell containing an email
address my Outlook program generates a blank email with the address in
the clicked cell as its address.  

How do I stop that from happening?

Musawwir Spiegel
(e-mail address removed)

I have two ways to eliminate this. First, when you enter an e-mail
address in a cell, precede it with an apostrophe and it will not
create an e-mail hotlink.
If you have many already, do a copy/ paste special/ values and it will
convert them all. You may have to paste them into a blank section of
cells, then copy/ paste back again.
 
M

Musawwir Spiegel

Thank you.


Trekman said:
I have two ways to eliminate this. First, when you enter an e-mail
address in a cell, precede it with an apostrophe and it will not
create an e-mail hotlink.
If you have many already, do a copy/ paste special/ values and it will
convert them all. You may have to paste them into a blank section of
cells, then copy/ paste back again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top