Email address hyperlinks

[Keith]

I'm using Excel 2000 to build a contact list. Several of
my contacts have more than one email address and I would
prefer to put all email addresses for an individual in a
single cell.

When I do this, all email addresses default to the email
hyperlink of the first email address in the cell.

Is there a way to enter multiple email addresses in a
single cell and have the hyperlinks correctly routed to
the appropriate email address?

TIA
Keith

 

[Dave Peterson]

not really.

but you could cheat. Add a couple of rectangles in that cell. Cover one
address with one rectangle and cover the other address with the second
rectangle.

Then assign a hyperlink to each rectangle. (and you could remove the
borders--so it doesn't even look like the rectangles are there.)

 

[Guest]

Cheating works for me. Thanks!

-----Original Message-----
not really.

but you could cheat. Add a couple of rectangles in that cell. Cover one
address with one rectangle and cover the other address with the second
rectangle.

Then assign a hyperlink to each rectangle. (and you could remove the
borders--so it doesn't even look like the rectangles are there.)


--

Dave Peterson
(e-mail address removed)
.