Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
email
Here's what I want to do:
Everytime I input a name, it represents the email address and automatically becomes a hyperlink. For example: John Smith will automatically become a hyperlink to . Is there some way that I can set John Smith = or something like that? Thanks, Scott |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
email
Try out the following:
In Excel menu- ----Tools - Options - Spelling -----Click on 'Auto Correct Options...' button ------Input the name (John Smith) in the text box labelled 'Replace:' and input the email id ) in the text box labelled 'With:'. ------Click on Add and click OK and close the window. Now, whenever you type John Smith and press the enter key, it will change to the email id. Note: Instead of putting the entrire name, you can use short names, what ever you like. For ex: for John Smith you input JS in the 'Replace:' text box mentioned above, so that when ever you type JS it gets converted to the email id. Hope this will help you. "Scott Marcus" wrote: Here's what I want to do: Everytime I input a name, it represents the email address and automatically becomes a hyperlink. For example: John Smith will automatically become a hyperlink to . Is there some way that I can set John Smith = or something like that? Thanks, Scott |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
email
Thank you. That's an idea. But here's the problem. I have a drop down box
of names which I use. And I want their names to appear in the box, not their email addresses. I want that when I select any name from the drop down box, it automatically becomes a hyperlink to the email address associated. Now the truth is, they are all outlook contacts, so the "mailto:" would be the name itself. Do you think this is possible? Thanks for all your help, Scott "Shameem" wrote: Try out the following: In Excel menu- ----Tools - Options - Spelling -----Click on 'Auto Correct Options...' button ------Input the name (John Smith) in the text box labelled 'Replace:' and input the email id ) in the text box labelled 'With:'. ------Click on Add and click OK and close the window. Now, whenever you type John Smith and press the enter key, it will change to the email id. Note: Instead of putting the entrire name, you can use short names, what ever you like. For ex: for John Smith you input JS in the 'Replace:' text box mentioned above, so that when ever you type JS it gets converted to the email id. Hope this will help you. "Scott Marcus" wrote: Here's what I want to do: Everytime I input a name, it represents the email address and automatically becomes a hyperlink. For example: John Smith will automatically become a hyperlink to . Is there some way that I can set John Smith = or something like that? Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why loss of excel formatting in email attachment on Win platform? | Excel Discussion (Misc queries) | |||
Move a Column of 500 Email Addresses into BCC Field of an Email | Excel Worksheet Functions | |||
Copy Excel email addresses to GroupWise | Excel Discussion (Misc queries) | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
background color showing only when in email form | Excel Discussion (Misc queries) |