Hyperlink to provide feedback
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 |
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. In article , "Smudger" wrote: 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 |
I do not have an E-Mail Address tab - I am using Excel 97 - Sorry - should
have said that before "Smudger" wrote: 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 |
Smudger
Under "Link to file or URL" put mailto: and it should work for you. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Smudger wrote: I do not have an E-Mail Address tab - I am using Excel 97 - Sorry - should have said that before "Smudger" wrote: 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 |
Small typo.
No space between the colon and name. Dick Kusleika wrote: Smudger Under "Link to file or URL" put mailto: and it should work for you. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Smudger wrote: I do not have an E-Mail Address tab - I am using Excel 97 - Sorry - should have said that before "Smudger" wrote: 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 -- Dave Peterson |
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, -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Dave Peterson wrote: Small typo. No space between the colon and name. Dick Kusleika wrote: Smudger Under "Link to file or URL" put mailto: and it should work for you. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Smudger wrote: I do not have an E-Mail Address tab - I am using Excel 97 - Sorry - should have said that before "Smudger" wrote: 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 |
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.) Dick Kusleika wrote: 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, -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Dave Peterson wrote: Small typo. No space between the colon and name. Dick Kusleika wrote: Smudger Under "Link to file or URL" put mailto: and it should work for you. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Smudger wrote: I do not have an E-Mail Address tab - I am using Excel 97 - Sorry - should have said that before "Smudger" wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 10:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com