Hyperlinks and Mailmerge

[Lance]

Using Word 2k, I want to mailmerge a URL in MS Word but I
don't want the text of the URL to show up I want "Click
Here" to show up as the hyperlink. I'm hoping that someone
has done this before -- since each URL will be different I
can't simply edit the text in MS Word afterwards -- I
can't find anything on this anywhere -- is it possible to
do?

Thanks in advance!

Lance

 

[Cindy M -WordMVP-]

Hi Lance,

This generally isn't possible. If the information in the
Hyperlink field is being merged into Word, then the best you
can do is to see the actualy link path. HOWEVER...

Since you want to have the *same* display text in all
instances, the following might work (I've never tried it,
myself):
- Create a hyperlink to any URL using Insert/Hyperlink and
enter the "Click Here" display text
- Alt+F9 to view the field codes
- replace the URL with the merge field for the URLs
- Alt+F9 again and run the merge

Based on what I've seen when Word merges into Hyperlink
fields, the display text should remain static...

Using Word 2k, I want to mailmerge a URL in MS Word but I
don't want the text of the URL to show up I want "Click
Here" to show up as the hyperlink. I'm hoping that someone
has done this before -- since each URL will be different I
can't simply edit the text in MS Word afterwards -- I
can't find anything on this anywhere -- is it possible to
do?

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

 

[Lance]

Cindy,

Thanks for the suggestion -- it didn't work right off but
it may eventually work... I'll play with it some more, the
link isn't going to the one that was originally set up but
it isn't going to where the link specified in my database
is pointing to either -- just passes some junk to Internet
Explorer which IE can't resolve. If I can figure out what
junk is being passed and get my URL there I should be o.k.
I'll let you know if I can get it to work. Thanks for the
ALT F9 tip, was looking for something like that but didn't
realize that ALT F9 would do it for me.

Lance

 

[Cindy M -WordMVP-]

Hi Lance,

Thanks for the suggestion -- it didn't work right off but
it may eventually work... I'll play with it some more, the
link isn't going to the one that was originally set up but
it isn't going to where the link specified in my database
is pointing to either -- just passes some junk to Internet
Explorer which IE can't resolve. If I can figure out what
junk is being passed and get my URL there I should be o.k.
I'll let you know if I can get it to work.

Yes, please I don't really use merge-to-hyperlink,
myself, but these kinds of questions pop up with "depressing"
regularity, and it helps to have an idea of what works under
which circumstances.

What does the URL that's not working look like? And what is
mail merge "spitting out"?

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