link e-mail address

Mar 11th, 2002, 06:22 AM

Is there a way to make e-mail address link to outlook express without having to go to hyperlinks and typing mailto:test@mymail.com ? in word it will automatically link when you type the address

Mar 11th, 2002, 01:39 PM

Mar 11th, 2002, 07:10 PM

there must be a way!

NateO · Mar 11th, 2002, 07:29 PM

In Excel 2000, if you type:

test@mymail.com

It should convert to a hyperlink. In fact, it will try to launch Outlook (which is no good or me personally). Are you in 97?

Nate

[ This Message was edited by: NateO on 2002-03-11 18:41 ]

Mar 11th, 2002, 08:10 PM

yes I am using '97

Anne Troy · Mar 11th, 2002, 08:17 PM

Hmmm.... I don't recall. I suppose you cannot choose Format-Cells and choose hyperlink, sooo...do this:

Copy those cells right into Word. It should create a column in Word that looks virtually the same.

Select the entire column. Hit Format-Style, make sure it says *all styles* at the bottom of the list. Choose Hyperlink. I'm almost certain 97 has that option. You can check before you move it to Word. If you get the hyperlink on there, go ahead and copy. Go back to Excel, click on first *bad* hyperlink cell and hit paste.

Mar 11th, 2002, 08:45 PM

When I right clicked to copy had to go to hyperlink copy hyperlink then pasted to excel, Thanks

Looking forward to your news letter

Mar 11th, 2002, 08:17 PM	#6
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Hmmm.... I don't recall. I suppose you cannot choose Format-Cells and choose hyperlink, sooo...do this: Copy those cells right into Word. It should create a column in Word that looks virtually the same. Select the entire column. Hit Format-Style, make sure it says all styles at the bottom of the list. Choose Hyperlink. I'm almost certain 97 has that option. You can check before you move it to Word. If you get the hyperlink on there, go ahead and copy. Go back to Excel, click on first bad hyperlink cell and hit paste. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 06:22 AM	#1
Guest Posts: n/a	Is there a way to make e-mail address link to outlook express without having to go to hyperlinks and typing mailto:test@mymail.com ? in word it will automatically link when you type the address

Mar 11th, 2002, 07:10 PM	#3
Guest Posts: n/a	there must be a way!

Mar 11th, 2002, 07:29 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	In Excel 2000, if you type: test@mymail.com It should convert to a hyperlink. In fact, it will try to launch Outlook (which is no good or me personally). Are you in 97? Nate [ This Message was edited by: NateO on 2002-03-11 18:41 ]

Mar 11th, 2002, 08:10 PM	#5
Guest Posts: n/a	yes I am using '97

Mar 11th, 2002, 08:45 PM	#7
Guest Posts: n/a	When I right clicked to copy had to go to hyperlink copy hyperlink then pasted to excel, Thanks Looking forward to your news letter