Merging hyper link from data source

[Jasy]

Merge Gurus

I have a problem while merging data from excel.
One of the data in the data source is a hyper link.
When I merge, only the text is appearing in the merged document.
Loosing the hyper link.

Can any body explain How can we retain the hyperlink after merging.

Jasy

 

[Doug Robbins]

This was posted by fellow MVP, Cindy Meister

"The only way Word can create a hyperlink is using a Hyperlink field. That
means that you have to pass the TEXT (URL) through the mail merge, and nest
the merge field into a Hyperlink field. Further, this has to be done as the
last step, and the mail merge executed immediately, to a NEW document,
before
hiding the merge field codes, then updating the fields.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org"

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jasy]

Could you please explain little in detail.
I could not understand " pass the TEXT (URL) through the mail merge".
Is it means to insert the field containg the hyperlink and do some editing
manually?

Jasy

 

[Cindy M -WordMVP-]

Hi Jasy,

Could you please explain little in detail.
I could not understand " pass the TEXT (URL) through the mail merge".
Is it means to insert the field containg the hyperlink and do some editing
manually?

I posted a reply to your query within another thread, giving you a link to a
new article in the MailMerge FAQ on my website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail