How do I show an email address in an Excel file?

[Buzzard]

How do I show an email address in an Excel file that I can click on to open
a new outgoing message in Outlook Express?

Buzz

 

[Frank Kabel]

Hi
if Outlook is the defined email client just enter your email in a cell
(Excel should convert this to a Hyperlink)

 

[Buzzard]

Hi Hi

I tried that . . . it doesn't work. I have Excel 97 SR-1.

Buzz

-----

 

[Dave Hawley]

Hi Buzz

As Frank has said, just typing it should be enough. If not, go to
Tools>Auto Correct Options-Auto Format as you type and check "Internet
and network paths as you type"

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Buzzard]

Hi Dave

I have Excel 97 SR-1. It does not have that option.

Buzz

 

[Andy Pope]

Hi Buzz,

Try this,

=HYPERLINK("mailto:[email protected]","(e-mail address removed)")

Cheers
Andy

 

[Dave Peterson]

I would have guessed that Frank's suggestion would have worked for you.

And Andy's suggestion should work, too:

=HYPERLINK("mailto:[email protected]","(e-mail address removed)")

But I'm wondering if simply typing:
mailto:[email protected]
Accomplishes the same thing.

And what does it didn't work mean?

Did Frank's suggestion insert the hyperlink, but it didn't start OE?
Or it didn't get converted to a hyperlink (clicking on it didn't do anything)?
Or it got converted to a hyperlink, but it didn't look like one?

 

[Dave Hawley]

Hi Buzz

I *think* from memory there is an option somewhere under Tools>Options
for Hyperlinks.

If these are imported try this URL
http://support.microsoft.com/default.aspx?scid=kb;en-us;271856&Product=x
lw97

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Andy Pope]

Hi Dave,

Does XL97 support the automatic creation of hyperlinks?
It maybe a option that I have switched off, but I can't find the switch

Cheers
Andy

 

[Dave Hawley]

Hi Andy

I'm not too sure. I think it does, but it's been a while and I don't
have 97 anymore.

If It's not under Tools>options or AutoCorect then maybe it doesn't.

BTW, check out O'Reilly, the book is up and should be out within a week.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Dave Peterson]

I think that this is one of those FAQ's about xl97--how to turn off the
automatic creation of hyperlinks. (The ability to turn it off was added later.)