General discussion

Locked

Excel 2000 Hyperlink

By cha1608t.hkm ·
When I enter an email addrsss in a column, the hyperlink properties will setup automatically such that when i click the email address, outlook express will start automatically. But if I use copy and paste option for this column, hyperlink properities will not set up, therefore can't run outlook express when i click the address. Now I made
a list of serveral hundred email address by copy and paste option by mistake, how can i set all the those hyperlink properities by just a few clicks or by marco, etc...

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 2000 Hyperlink

by cha1608t.hkm In reply to Excel 2000 Hyperlink

Point value changed by question poster.

Collapse -

Excel 2000 Hyperlink

by cha1608t.hkm In reply to Excel 2000 Hyperlink

Point value changed by question poster.

Collapse -

Excel 2000 Hyperlink

by awilliams3 In reply to Excel 2000 Hyperlink

A quick and dirty VBA routine...

Sub converttomailhyperlink()
Dim rngItem As Excel.Range

On Error Resume Next
For Each rngItem In Selection
rngItem.Parent.Hyperlinks.Add anchor:=rngItem, _
Address:="Mailto:" & rngItem.Value, _
TextToDisplay:=rngItem.Value
Next rngItem
On Error GoTo 0
End Sub

Highligh the range of data in question and execute the above routine. Test first!

Note, this does not work for Excel 97 (drop the TextToDisplay argument).

Collapse -

Excel 2000 Hyperlink

by cha1608t.hkm In reply to Excel 2000 Hyperlink

Poster rated this answer

Collapse -

Excel 2000 Hyperlink

by cha1608t.hkm In reply to Excel 2000 Hyperlink

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums