PC Review


Reply
Thread Tools Rate Thread

Automatic email addresses

 
 
chesjak
Guest
Posts: n/a
 
      3rd Mar 2009
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
 
Reply With Quote
 
 
 
 
Sheeloo
Guest
Posts: n/a
 
      3rd Mar 2009
There might be formulas like
=HYPERLINK("private.php?do=newpm&u=","Test email address")

It will show Test email address in the cell but when you click, it will
prepare a mail to (E-Mail 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

"chesjak" wrote:

> 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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic updating of email addresses in OE Swirl Microsoft Access 0 12th Jan 2007 01:09 PM
automatic completion of email addresses =?Utf-8?B?UmljaGFyZCBFbWFpbA==?= Microsoft Outlook Discussion 2 29th Sep 2004 04:58 PM
Automatic Addition of Email addresses Michelle Microsoft Outlook 2 28th Jan 2004 08:02 PM
Automatic adding of email addresses? Scott Holmes Microsoft Outlook 0 15th Oct 2003 03:06 AM
automatic completion of email addresses M Seager Microsoft Outlook 0 18th Jul 2003 09:26 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:05 PM.