Changing hyperlink email address fail

[exceedingly frustrated]

Have a quick question.

Need to change some information in a column list of email addresses that are hyperlinked to outlook.

Most addresses are correct with a hyperlink that works well. I have a couple of addresses that have information in the cell that opens up an outlook message to a different email address. Hovering over a cell with aaaaaa@xyz.com shows the message mailto:xxxxx@abc.com.

How do I change the hyperlink to the correct email address?

Thanks,
EF

 

[bugmonsta]

Right click you cell and choose edit hyperlink...or when on the cell press ctrl-k to do the same.

You will see there is an email address and text displayed options that you can change.

For more information - Work with hyperlinks in Excel - Excel

 

[FormR]

How do I change the hyperlink to the correct email address?

Hi, if you are looking for some code to update en masse, then you could give this a try on a copy of your workbook:

Sub FixHyperLinks()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
    If UCase(Left(HL.Address, 7)) = "MAILTO:" Then HL.Address = "MailTo:" & HL.TextToDisplay
Next HL
End Sub