Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Hyperlink in clipboard for Outlook Email

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ryanmhuc@yahoo.com - 12 May 2008 04:08 GMT
Is it possible to create a hyperlink and place this in the clipboard
so you can paste it into an Outlook email. I know i can do something
like this

"<file:///E:\Profile\Desktop\dropbox\sharepoint.docx>"

And then after a return it will hyperlink. But i would like the link
and the text to be different.
Tony Jollans - 12 May 2008 11:26 GMT
Copy (and Paste) will copy a hyperlink along with any displayed text. If
your problem is really just that you want text and address to be different
in the first place, use the hyperlinks dialog - you don't say what version
of Word you are using but placing the insertion point in the hyperlink and
pressing Ctrl+K works in all versions.

Signature

Enjoy,
Tony

> Is it possible to create a hyperlink and place this in the clipboard
> so you can paste it into an Outlook email. I know i can do something
[quoted text clipped - 4 lines]
> And then after a return it will hyperlink. But i would like the link
> and the text to be different.
ryanmhuc@yahoo.com - 12 May 2008 16:53 GMT
On May 12, 6:26 am, "Tony Jollans" <My forename at my surname dot com>
wrote:
> Copy (and Paste) will copy a hyperlink along with any displayed text. If
> your problem is really just that you want text and address to be different
[quoted text clipped - 20 lines]
>
> - Show quoted text -

Tony thanks for the suggestion but I'm asking how you accomplish this
in VBA. Obivously using the copy and paste from the keyboard will work
but how do you create the same affect using VBA and the clipboard
Tony Jollans - 12 May 2008 17:57 GMT
I'm not entirely sure what you want. This is a Word group so do you want to
know how to create a hyperlink in Word VBA. If so, try this:

   (range_reference).Hyperlinks.Add Anchor:=Selection.Range, _
       Address:="http://www.example.com", TextToDisplay:="Example text"

If you want to copy a hyperlink to the clipboard, then this:

   (range_reference).Hyperlinks(1).Range.Copy

If you want to conjure the hyperlink out of thin air and on to the clipboard
without an intermediate step, I'm not sure that can be done.

Or are you actually in Outlook? And if so, what version?

Signature

Enjoy,
Tony

On May 12, 6:26 am, "Tony Jollans" <My forename at my surname dot com>
wrote:
> Copy (and Paste) will copy a hyperlink along with any displayed text. If
> your problem is really just that you want text and address to be different
[quoted text clipped - 20 lines]
>
> - Show quoted text -

Tony thanks for the suggestion but I'm asking how you accomplish this
in VBA. Obivously using the copy and paste from the keyboard will work
but how do you create the same affect using VBA and the clipboard
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.