PC Review


Reply
Thread Tools Rate Thread

how can I convert text to hyperlink

 
 
Gordon
Guest
Posts: n/a
 
      12th Oct 2009

I get emails in OE from yahoo groups with links that are split into 3 or 4
lines and only part of the link is shown as hypertext (blue) the rest is just
black. Is there a way I can copy all of it to Word and convert the black part
to blue? I can copy the link to a Word doc, highlight and copy the black
under edit but the "paste as hyperlink" option is not available to me.
 
Reply With Quote
 
 
 
 
Graham Mayor
Guest
Posts: n/a
 
      12th Oct 2009
Without knowing exactly what we are dealing with we can only assume that the
mail reader has added hard returns at the end of each line. The only way to
deal with this would be to remove the hard returns from the lines and
autoformat to convert links to hyperlinks. You could automate that with a
macro. Select the broken link and run the following.

Sub ReLink()
Dim oRng As Range
Set oRng = Selection.Range
With oRng
.Text = Replace(.Text, Chr(13), "")
.Text = Replace(.Text, Chr(11), "")
With Options
.AutoFormatApplyHeadings = False
.AutoFormatApplyLists = False
.AutoFormatApplyBulletedLists = False
.AutoFormatApplyOtherParas = False
.AutoFormatReplaceQuotes = False
.AutoFormatReplaceSymbols = False
.AutoFormatReplaceOrdinals = False
.AutoFormatReplaceFractions = False
.AutoFormatReplacePlainTextEmphasis = False
.AutoFormatReplaceHyperlinks = True
.AutoFormatPreserveStyles = False
.AutoFormatPlainTextWordMail = False
End With
.AutoFormat
End With
End Sub

http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Gordon wrote:
> I get emails in OE from yahoo groups with links that are split into 3
> or 4 lines and only part of the link is shown as hypertext (blue) the
> rest is just black. Is there a way I can copy all of it to Word and
> convert the black part to blue? I can copy the link to a Word doc,
> highlight and copy the black under edit but the "paste as hyperlink"
> option is not available to me.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert text to hyperlink Ryer Microsoft Excel Misc 3 9th Sep 2009 04:59 PM
convert text to hyperlink se7098 Microsoft Excel Worksheet Functions 2 2nd Feb 2009 10:54 PM
Convert Text to Hyperlink =?Utf-8?B?TGVlTWF4?= Microsoft Word Document Management 2 10th Nov 2006 04:04 PM
Re: Fast Way to Convert HyperLink to Text Dana DeLouis Microsoft Excel Misc 0 17th Sep 2003 05:50 AM
Re: Fast Way to Convert HyperLink to Text J.E. McGimpsey Microsoft Excel Misc 0 16th Sep 2003 09:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:34 PM.