>I have received a document which is choc-a-block with linked email
>addresses
[quoted text clipped - 6 lines]
> away
> via a macro?
Hi Oz
Yup, there is.
Sub RemoveHyperlinks()
Dim n as Long
With ActiveDocument.Hyperlinks
For n = 1 to .Count
.Item(1).Delete
Next n
End With
End Sub
This will remove all hyperlinks and leave all other fields intact.

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Oz Springs - 14 Jan 2005 15:39 GMT
Thank you very much. A reply in 7 minutes. I didn¹t even have enough time to
return to my laborious semi-manual hyperlink removal.
Kind regards
Oz
On 14/1/05 15:27, in article uVhuF2k#EHA.2876@TK2MSFTNGP12.phx.gbl,
>> I have received a document which is choc-a-block with linked email
>> addresses
[quoted text clipped - 21 lines]
>
> This will remove all hyperlinks and leave all other fields intact.
> I have received a document which is choc-a-block with linked email
> addresses which make it hard for me to copy and paste. I don?t need
[quoted text clipped - 8 lines]
>
> Oz
Hi Oz,
If the hyperlinks are the only fields in the document, or if you don't care
about the other fields, you can do it in the GUI with two keystrokes.
Ctrl+A -- Select all
Ctrl+Shift+F9 -- Unlink fields
This converts all fields to plain text of their displayed results.
If there are other fields that need to remain as fields, use this macro to
unlink only the hyperlinks:
Sub UnlinkHyperlinks()
Dim nHL As Long
For nHL = 1 To ActiveDocument.Hyperlinks.Count
ActiveDocument.Hyperlinks(1).Delete
Next nHL
End Sub
Two notes:
- The .Delete method in VBA does the same as Unlink in the GUI -- it will
leave the display text in place. To remove the entire thing, you need to do
.Hyperlinks(1).Range.Delete.
- As each hyperlink is deleted, the next one becomes .Hyperlinks(1). This
technique is needed because the Hyperlinks collection doesn't work properly
in a For Each loop in which the number of hyperlinks is being changed by
.Delete or .Add.

Signature
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Oz Springs - 14 Jan 2005 18:37 GMT
Hi Jay
Thanks for this. I¹ll have to check that I haven¹t replaced Command+Shift+F9
with something else (or if this is a shortcut on a Mac). It will be handy to
know when to convert all fields - instantly.
I¹ll test out the other macro on my document. The one which Jonathan sent me
worked instantly, even quicker than removing one hyperlink with my old
method.
Truly amazed.
Oz
On 14/1/05 15:40, in article OmtoX9k#EHA.1264@TK2MSFTNGP12.phx.gbl, "Jay
Freedman" <jay.freedman@verizon.net> wrote:
>> I have received a document which is choc-a-block with linked email
>> addresses which make it hard for me to copy and paste. I don¹t need
[quoted text clipped - 38 lines]
> in a For Each loop in which the number of hyperlinks is being changed by
> .Delete or .Add.
Jay Freedman - 14 Jan 2005 19:17 GMT
Hi Oz,
Jonathan's macro and mine work the same way. The difference is just in the
way we expressed the names of the hyperlinks in order to delete them.

Signature
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
> Hi Jay
> Thanks for this. I?ll have to check that I haven?t replaced
[quoted text clipped - 54 lines]
>> work properly in a For Each loop in which the number of hyperlinks
>> is being changed by .Delete or .Add.