Hyperlink to provide feedback

S

Smudger

Hi,

All I want to do is set up a hyperlink on an Excell sheet - When pressed
this will create a mail in outlook with the address pre-filled - Is this
possible - I have tried the ronbru... website that you refer to quite a bit
but nothing there seems to help.

I am really desperate now! ;o)

Smudger
 
J

JE McGimpsey

One way:

Select your cell. Choose Insert/Hyperlink. Click the E-mail Address tab.
Insert your address in the To: field. Insert the subject in the Subject
field, if desired. Click OK.
 
S

Smudger

I do not have an E-Mail Address tab - I am using Excel 97 - Sorry - should
have said that before
 
D

Dick Kusleika

Not really a typo - I just don't know any better.:) Oddly, it works with
the space. Good ol' Excel, correcting my errors again.

Thanks,
 
D

Dave Peterson

Ah. I just typed that into the cell in a worksheet (just plain old data
entry--not a hyperlink).

It didn't work there. (But it did work when I put it in the Insert|Hyperlink
dialog. But it kept that leading space in the address in the email <vbg>.)
 
Top