Hyperlink disappears

P

Patty

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
 
C

Cindy M -WordMVP-

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?
Click to expand...

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

Patty

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
 
P

Patty

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
 
C

Cindy M -WordMVP-

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
to be with only one of the documents.

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.
Click to expand...

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

Patty

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
 
C

Cindy M -WordMVP-

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
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?
Click to expand...

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

Guest

The real code has the hyperlink in it. An example is

{HYPERLINK "http://www.nus.com?advquery=field recnum:
{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
 
C

Cindy M -WordMVP-

The real code has the hyperlink in it. An example is
{HYPERLINK "http://www.nus.com?advquery=field recnum:
{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.
Click to expand...
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 :)
 
P

Patty Day

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 } }
 
C

Cindy M -WordMVP-

Hi Patty,
Here is the "real code"!
Click to expand...
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
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
:)
 
P

Patty Day

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink fails to open on the first click 0
Mail merge hyperlink wrong results 0
Microsoft 365 Activations, Users or Devices? 0
Print hyperlink when saving to PDF 0
Print hyperlink when saving to PDF. 1
Can't set display text for hyperlink created in merged Word doc fromExcel data source 12
Endnotes disappear from screen in Word 2007 Print Layout 0
URL in HYPERLINK shortened after email merge 0

Top