Hi,

I have been looking everywhere for an answer for this, but found none....
I hope you guys can help me:

I would like to create a working mail merge url BUT to keep the text displayed as the actual custom generated url.

I'll elaborate:
Today if I want to create a working url that changes according to recipient I have to wrap it with a hyper link field that displays a text, for example the code is:
{HYPERLINK http://www.example.com/id={MERGEFIELD id} \*MERGEFORMAT}
and I need to write a text to be displayed, usually "click here"

I would like the text that is displayed to be
http://www.example.com/id={MERGEFIELD id}
for example
http://www.example.com/id=3



Needless to say that if I get rid of the:{HYPERLINK \*MERGEFORMAT}
the URL is not generated correctly i.e just the "http://www.example.com/id=" is a functioning URL and the actual value for ID (for example 3) is a text, this causes the user to reach an error page when clicked.

Any help??

By default, if you insert a mailmerge field into a hyperlink field, the hyperlinks will all show the first record’s address as the 'Text to display' text. Here's how you can do get a mailmerge to display your preferred default 'Text to display' text instead:
1. Disregarding mergefield issues for the moment, insert a hyperlink into the document in the normal way, choosing whatever 'Click Here' text you want in the 'Text to display' box.
2. Select the inserted hyperlink and press Shift-F9 to expose its field code.
3. Replace everything in the field after 'HYPERLINK' with your mergefield.
4. Select the field and press F9 to update the display.

In Word 2007 & later, you can make the display text variable also, by following these additional steps:
5. Position the cursor anywhere within the display text.
6. Insert a mergefield pointing to whatever data field you want to use for the display text (this could even be the same field as used at step 3 above).
7. Delete all of the previous display text either side of your last-inserted mergefield (note that this field will likely have updated already).
8. Execute the merge.
9. After merging to a new document, use Ctrl-A, F9 to update all fields. Without this, the mergefield hover text won’t update to the correct targets.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]