Automatic email addresses

[chesjak]

Hi

I am using Windows XP pro with Office XP 2003 pro

I am using a spreadsheet set up by a company I work for and in aone column
is email addresses. If I click on an address it turns blue and I am directed
to my email window in Outlook ready for me to send an email. The address I
clicked on in excel is automatically put into the send to window in outlook.
However, on some of the addresses in the excel spreadsheet the name that
appears in outlook is completely different to the email address that is in
the spreadsheet.

I don't know where the email address has come from because it is not one I
recognise at all and I definitely have not put it on my system.

The I.T. person that designed the spreadsheet says that this is an excel
issue and he has not programmed the system to setup emails so it is an
automated function of excel.

Is this so?
and also where would the email address that appears in the outlook window
have come from? as I siad they have not been put into my system by me and I
am the only person that uses the system.

Any help would be appreciated

Regards

 

[Sheeloo]

There might be formulas like
=HYPERLINK("mailto:[email protected]","Test email address")

It will show Test email address in the cell but when you click, it will
prepare a mail to (e-mail address removed).

If you hover over the cell you may see a link like mailto:...

If this does not work then you may copy the formula in one of the cells here