 |
 | 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 / January 2004Hyperlink disappears
We just upgraded to Office 2003. We have been successfully using hyperlinks in Word 2000 merge documents for a couple of years. However, in Word 2003, after we perform the merge, the hyperlink disappears (words are there, "See More," but "active" link is gone). Anyone else experiencing problems? Is it a setting we're missing? Thanks for any help. patty Hi Patty, Are you merging to Text or to HTML email format? To which email software are you merging? > We just upgraded to Office 2003. We have been > successfully using hyperlinks in Word 2000 merge documents > for a couple of years. However, in Word 2003, after we > perform the merge, the hyperlink disappears (words are > there, "See More," but "active" link is gone). Anyone > else experiencing problems? Is it a setting we're missing? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Hi Cindy, I'm mergeing an Access database to a Word (2003) document. The merge document is a little complex, but it has worked for a long time with previous versions of Office. It appears that the hyperlink is okay until you view the field codes. In other words, if I don't view the field codes, the link stays, but since I am merging a field into the hyperlink, I have to be able to view the field codes. Thanks in advance for any assistance! patty >-----Original Message----- >Hi Patty, [quoted text clipped - 20 lines] > >. Cindy, After further investigation, it seems that most of the Word merge documents work properly. The problem appears to be with only one of the documents. I'm still trying to figure it out, but the field codes issues was imagined, not real. Thanks, patty >-----Original Message----- >Hi Patty, [quoted text clipped - 20 lines] > >. Hi Patty, In this case, it's possible that the document, or the field code itself, might be damaged. I'd set up a new main merge document (or template, whichever you're using). Copy the text up, but not with, the field code. And also do NOT copy the last paragraph mark. Take care of any necessary formatting (such as margins, headers, footers) and link to the data source. Recreate the Hyperlink field. Test. > it seems that most of the > Word merge documents work properly. The problem appears [quoted text clipped - 9 lines] > stays, but since I am merging a field into the hyperlink, > I have to be able to view the field codes. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Cindy, I've narrowed my problem down to merge documents that contain IF statements. The document merges perfectly until I reinsert my IF statements. I am using code simliar to the code contained in Microsoft's article Q211303. { If { MERGESEQ } = "1" "{ MERGEFIELD City }" ""}<ENTER> { SET Place1 { MERGEFIELD City }}<ENTER> { If { Place2 } <> { Place1 }"<ENTER> ----------------------------Page Break--------------------- ----------- { MERGEFIELD City }<ENTER> <ENTER> { MERGEFIELD Employee }{ MERGEFIELD Sales }" "{ MERGEFIELD Employee }{ MERGEFIELD Sales }" }{ SET Place2 { MERGEFIELD City }} As I've said, this same code worked fine in Word 2000. I'm wondering if it's something to do with the quotation marks? Thanks for your help. patty >-----Original Message----- >Hi Patty, [quoted text clipped - 34 lines] > >. Hi Patty, And where are the Hyperlink fields in relation to all of this? To what quotation marks are you referring, more specifically? > I've narrowed my problem down to merge documents that > contain IF statements. The document merges perfectly [quoted text clipped - 17 lines] > I'm wondering if it's something to do with the quotation > marks? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Hi Cindy, My merge fields would be where indicated below. >> { If { MERGESEQ } = "1" "{ MERGEFIELD City }" ""}<ENTER> >> { SET Place1 { MERGEFIELD City }}<ENTER> [quoted text clipped - 4 lines] >> <ENTER> >> { MERGEFIELD Employee }{ MERGEFIELD Sales }{Patty's MERGEFIELD link}" "{ MERGEFIELD >> Employee }{ MERGEFIELD Sales }{Patty's MERGEFIELD link}" }{ SET Place2 { MERGEFIELD >> City }} >> Thanks, patty >-----Original Message----- >Hi Patty, [quoted text clipped - 35 lines] > >. but I don't see any HYPERLINK fields in here? Word requires a hyperlink "path" to be in a Hyperlink field (Insert/Hyperlink)... > My merge fields would be where indicated below. > [quoted text clipped - 11 lines] > link}" }{ SET Place2 { MERGEFIELD > >> City }} Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) The real code has the hyperlink in it. An example is {HYPERLINK "http://www.nus.com?advquery=field%20recnum%3a {MERGEFIELD recnum}"} As I said, this worked for years with Word 2000, just stopped working with Word 2002. Also, the hyperlink works fine as long as I leave the IF statement out. So it's something to do with that. patty >-----Original Message----- >but I don't see any HYPERLINK fields in here? Word requires a [quoted text clipped - 27 lines] > >. > The real code has the hyperlink in it. An example is > [quoted text clipped - 5 lines] > fine as long as I leave the IF statement out. So it's > something to do with that. Yes, and now please show me the entire "real code", as I asked you a couple of messages back. It's not possible for us to test things, look for solutions, and track down bugs if we don't have the complete information. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Hi Cindy, Sorry to be such a pain. Here is the "real code"! I was trying to figure out a way to not have to retype the whole thing. Finally did! Thanks for anything you can do. patty { IF { MERGESEQ } = "1" " License Amendments { MERGEFIELD StatusDescription} "" }{ SET Year1 { MERGEFIELD status1 } }{ If { Year2 } <> { Year1 } " License Amendments { MERGEFIELD StatusDescription} { MERGEFIELD affected_sites } NSSS: { IF { MERGEFIELD peer_group_id } = 1 "Combustion Engineering" "" }{ IF { MERGEFIELD peer_group_id } = 2 "Combustion Engineering" "" }{ IF { MERGEFIELD peer_group_id } = 3 "General Electric" "" }{ IF { MERGEFIELD peer_group_id } = 4 "General Electric" "" }{ IF { MERGEFIELD peer_group_id } = 5 "B&W" "" }{ IF { MERGEFIELD peer_group_id } = 6 "Westinghouse" "" }{ IF { MERGEFIELD peer_group_id } = 7 "Westinghouse" "" }{ IF { MERGEFIELD peer_group_id } = 8 "Westinghouse" "" }{ IF { MERGEFIELD peer_group_id } = 9 "Westinghouse" "" }{ IF { MERGEFIELD peer_group_id } = "R" "Retired" "" } EXIGENT/EMERGENCY: { IF { MERGEFIELD exigentemergency } = 0 "No" "Yes" } ISTS: { MERGEFIELD ISTS } SUBMITTAL DATE: { MERGEFIELD "submittal_date1" }{ MERGEFIELD SubDate_String } STATUS: { MERGEFIELD status1 } { IF { MERGEFIELD status2 } <> "" ", " "" }{ MERGEFIELD status2 } NRC APPROVAL DATE: { MERGEFIELD final_date1 } { IF { MERGEFIELD final_date2 } <> "" ", " "" }{ MERGEFIELD final_date2 } Amendment No(s): { MERGEFIELD AmendNos } Record No.: { MERGEFIELD recnum } { HYPERLINK "http://www.nusis.com/sd_cgi-bin/om_isapi.dll? &advquery=%5bfield%20recnum%3a { MERGEFIELD recnum } % 5d&recordswithhits=on&headingswithhits=on&infobase=amend.nf o&softpage=Browse_Frame_Pg42&x=4 2&y=19&zz= " } { MERGEFIELD Description } " " { MERGEFIELD affected_sites } NSSS: { IF { MERGEFIELD peer_group_id } = 1 "Combustion Engineering" "" }{ IF { MERGEFIELD peer_group_id } = 2 "Combustion Engineering" "" }{ IF { MERGEFIELD peer_group_id } = 3 "General Electric" "" }{ IF { MERGEFIELD peer_group_id } = 4 "General Electric" "" }{ IF { MERGEFIELD peer_group_id } = 5 "B&W" "" }{ IF { MERGEFIELD peer_group_id } = 6 "Westinghouse" "" }{ IF { MERGEFIELD peer_group_id } = 7 "Westinghouse" "" }{ IF { MERGEFIELD peer_group_id } = 8 "Westinghouse" "" }{ IF { MERGEFIELD peer_group_id } = 9 "Westinghouse" "" }{ IF { MERGEFIELD peer_group_id } = "R" "Retired" "" } EXIGENT/EMERGENCY: { IF { MERGEFIELD exigentemergency } = 0 "No" "Yes" } ISTS: { MERGEFIELD ISTS } SUBMITTAL DATE: { MERGEFIELD "submittal_date1" }{ MERGEFIELD SubDate_String } STATUS: { MERGEFIELD status1 } { IF { MERGEFIELD status2 } <> "" ", " "" }{ MERGEFIELD status2 } NRC APPROVAL DATE: { MERGEFIELD final_date1 } { IF { MERGEFIELD final_date2 } <> "" ", " "" }{ MERGEFIELD final_date2 } Amendment No(s): { MERGEFIELD AmendNos } Record No.: { MERGEFIELD recnum } { HYPERLINK "http://www.nusis.com/sd_cgi-bin/om_isapi.dll? &advquery=%5bfield%20recnum%3a { MERGEFIELD recnum } % 5d&recordswithhits=on&headingswithhits=on&infobase=amend.nf o&softpage=Browse_Frame_Pg42&x=4 2&y=19&zz= " } { MERGEFIELD Description } " } { SET Year2 { MERGEFIELD status1 } } >-----Original Message----- >> The real code has the hyperlink in it. An example is [quoted text clipped - 22 lines] > >. Hi Patty, > Here is the "real code"! OK, I see it, now. I'm not sure what has been changed, here, exactly, but there seem to be a number of problems with Hyperlink fields. They're not even active when I use IncludeText to bring in text with hyperlinks from another file, when nested in an IF field. About the only solution I can suggest would be to generate the hyperlinks (or even the entire conditional text) using VBA, during the merge. Word 2002 introduced "mail merge events" that lets you manipulate the merge for each individual record. You'll find more about this capability in an article on the msdn website. Search there on my name, and look for the one about new things in Word 2002. You'll find a disucssion, along with some sample code that demonstrates how it works. Cindy Meister  SignatureINTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Thanks, Cindy. I'm just glad to know it wasn't me. And, I can't believe I'm the only one having this problem. Since we have many of these types of documents, I'm sorry to say this is not good news. Hopefully, I can get IT to hold off on the software upgrade on several machines until we can get the code redone. Thanks again for all your assistance. patty >-----Original Message----- >Hi Patty, [quoted text clipped - 29 lines] > >. |
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.