 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2005Merging hyper link from data source
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"  SignatureHope 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 > Merge Gurus > [quoted text clipped - 6 lines] > > 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 > This was posted by fellow MVP, Cindy Meister > [quoted text clipped - 22 lines] >> >> 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 :-) |
Reply to this Message |
 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.