Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-mail Addresses in Excel
I am using Excel for a simple database. One column contains e-mail
addresses. When I click on an address, it jump starts Outlook, which I don't use. I lose a lot of time closing it. Is there some way to turn off the auto start? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-mail Addresses in Excel
To delete the existing hyperlinks and leave only the email
messages as text, use the following macro: Sub AAA() Dim Rng As Range For Each Rng In Selection.Cells Rng.Hyperlinks.Delete Next Rng End Sub Select the cells in question and run the code. To prevent Excel from automatically changing email addresses to hyperlinks, go to the Tools menu, choose AutoCorrect Options, then the "AutoFormat As You Type" tab, and uncheck "Internet and network paths with hyperlinks." -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Kim" wrote in message ... I am using Excel for a simple database. One column contains addresses. When I click on an address, it jump starts Outlook, which I don't use. I lose a lot of time closing it. Is there some way to turn off the auto start? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-mail Addresses in Excel
Select the whole range which has email address, then right click your mouse,
then select remove hyperlink. -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "Kim" wrote in message ... I am using Excel for a simple database. One column contains e-mail addresses. When I click on an address, it jump starts Outlook, which I don't use. I lose a lot of time closing it. Is there some way to turn off the auto start? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
mail merging when you only have 2 excel spreadsheets | Excel Discussion (Misc queries) | |||
delete multiple addresses in excel before mail merge | Excel Discussion (Misc queries) | |||
E-mail addresses in Excel 2000 | Excel Discussion (Misc queries) | |||
mail merge from excel want day & month only | Excel Discussion (Misc queries) |