Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mailto addresses
i maintain a database in excel which includes mailto: addresses. when a
change to the mailto address is necessary, it displays the proper address but when clicked to send an email, it remembers the old mailto address that was first input in the cell. How can i get excel to disassociate from an address once it's changed? |
#2
|
|||
|
|||
Hi Nona,
The easy way to disassociate is to edit the hyperlink, i.e. right click the cell or go to INSERT menu, HYPERLINK, edit/change as per your need. Try this and your prob will be solved. Regards, PDS. "Nona" wrote: i maintain a database in excel which includes mailto: addresses. when a change to the mailto address is necessary, it displays the proper address but when clicked to send an email, it remembers the old mailto address that was first input in the cell. How can i get excel to disassociate from an address once it's changed? |
#3
|
|||
|
|||
Hi Nona,
I've certainly seen old links in a cell if you use Ctrl+K (right click, edit hyperlink) you can see it. I can't duplicate it manually, I think possibly you rewrote what you see with a macro and didn't touch the link. One way of getting around the problem would be to use something like A3: B3: =HYPERLINK("mailto:" & A3, "send") You can use a macro to eliminate existing object links (Ctrl+K), for a selection. There is also a macro to eliminate all hyperlinks, but I'd always use the one for the selection and have prepared the selection with Ctrl+A to select all cells, so I only have to use one macro, see http://www.mvps.org/dmcritchie/excel...#DelHyperlinks --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Pritesh Shah" wrote ... The easy way to disassociate is to edit the hyperlink, i.e. right click the cell or go to INSERT menu, HYPERLINK, edit/change as per your need. "Nona" wrote: i maintain a database in excel which includes mailto: addresses. when a change to the mailto address is necessary, it displays the proper address but when clicked to send an email, it remembers the old mailto address that was first input in the cell. How can i get excel to disassociate from an address once it's changed? |
#4
|
|||
|
|||
Never had Outlook Express lockup a reply before, guess it got sent
and couldn't do anything with what I thought was still my active reply no insert, no delete, no send, there was a Save As but I saved to notepad, anyway was going to add the following to what I just wrote. If you are using a macro to change the the data, you can include code in the macro to either write or remove the hyperlink. Just gave you something to remove a hyperlink, instead of selection you might use a single cell range typically. Adding a hyperlink you will find on the same webpage buildtoc.htm, of course if doing more than one it would not be for the activecell. ActiveSheet.Hyperlinks.Add Anchor:=ActiveCell, Address:=ActiveCell.Value --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "David McRitchie" wrote in message ... Hi Nona, I've certainly seen old links in a cell if you use Ctrl+K (right click, edit hyperlink) you can see it. I can't duplicate it manually, I think possibly you rewrote what you see with a macro and didn't touch the link. One way of getting around the problem would be to use something like A3: B3: =HYPERLINK("mailto:" & A3, "send") You can use a macro to eliminate existing object links (Ctrl+K), for a selection. There is also a macro to eliminate all hyperlinks, but I'd always use the one for the selection and have prepared the selection with Ctrl+A to select all cells, so I only have to use one macro, see http://www.mvps.org/dmcritchie/excel...#DelHyperlinks --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Pritesh Shah" wrote ... The easy way to disassociate is to edit the hyperlink, i.e. right click the cell or go to INSERT menu, HYPERLINK, edit/change as per your need. "Nona" wrote: i maintain a database in excel which includes mailto: addresses. when a change to the mailto address is necessary, it displays the proper address but when clicked to send an email, it remembers the old mailto address that was first input in the cell. How can i get excel to disassociate from an address once it's changed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I prevent email addresses from automatically hyperlinking. | Excel Worksheet Functions | |||
Removing house numbers from addresses | Excel Worksheet Functions | |||
Working with mac addresses | Excel Discussion (Misc queries) | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
Editing Multiple E-Mail Addresses... | Excel Worksheet Functions |