Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-Mail Issue in Excel
An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try to click on and/or enter data into, a new mail message opens up in Outlook to one of those email addresses. I can not figure out how to get this to stop and neither can my superior. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-Mail Issue in Excel
If you are comfortable with VBA, just highlight your data and type
"Selection.hyperlinks.delete" in the immediate window. 1. Hit Alt-F11 to bring up the VB Editor 2. Ctrl-G to bring up the Immediate Window 3. type "selection.hyperlinks.delete" and hit enter The hyperlinks should be gone. HTH, JP On Nov 13, 1:35 pm, Susan wrote: An Excel spreadsheet was sent to me by a superior in my office. There are E-Mail addresses in one column. There are multiple columns that when you try to click on and/or enter data into, a new mail message opens up in Outlook to one of those email addresses. I can not figure out how to get this to stop and neither can my superior. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-Mail Issue in Excel
"Susan" wrote:
An Excel spreadsheet was sent to me by a superior in my office. There are E-Mail addresses in one column. There are multiple columns that when you try to click on and/or enter data into, a new mail message opens up in Outlook to one of those email addresses. I can not figure out how to get this to stop and neither can my superior. Try this: 1) right click on the cell with the email 2) select "remove hyperlink" 3) click on the "format painter icon" 4) select the colums with the email addresses. This should remove the hyperlinks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-Mail Issue in Excel
Thanks for the quick solution. This worked great!
"JP" wrote: If you are comfortable with VBA, just highlight your data and type "Selection.hyperlinks.delete" in the immediate window. 1. Hit Alt-F11 to bring up the VB Editor 2. Ctrl-G to bring up the Immediate Window 3. type "selection.hyperlinks.delete" and hit enter The hyperlinks should be gone. HTH, JP On Nov 13, 1:35 pm, Susan wrote: An Excel spreadsheet was sent to me by a superior in my office. There are E-Mail addresses in one column. There are multiple columns that when you try to click on and/or enter data into, a new mail message opens up in Outlook to one of those email addresses. I can not figure out how to get this to stop and neither can my superior. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-Mail Issue in Excel
Glad we could help!
--JP On Nov 15, 9:46 am, Susan wrote: Thanks for the quick solution. This worked great! "JP" wrote: If you are comfortable with VBA, just highlight your data and type "Selection.hyperlinks.delete" in the immediate window. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
E-Mail Issue in Excel
I had the same problem, and JP's solution was perfect! Thank you!
"Susan" wrote: An Excel spreadsheet was sent to me by a superior in my office. There are E-Mail addresses in one column. There are multiple columns that when you try to click on and/or enter data into, a new mail message opens up in Outlook to one of those email addresses. I can not figure out how to get this to stop and neither can my superior. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E-Mail attachment to same e-mail address in Outlook | Excel Discussion (Misc queries) | |||
E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
Mail Merge issue | Excel Discussion (Misc queries) | |||
Error: cannot load the mail service. Check your mail installation. | Excel Discussion (Misc queries) | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) |