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

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" wrote in message
...
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

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


"Doug Robbins" wrote in message
...
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" wrote in message
...
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

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 :-)