#1
|
|||
|
|||
Mail Merge URL - a unique question
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?? |
#2
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Simple Mail Merge Question | Ethanflux | Mail Merge | 1 | 09-29-2013 07:21 PM |
Mail merge question | Saikological | Mail Merge | 1 | 01-29-2013 07:16 PM |
Mail Merge Question | markxyzbc | Word | 0 | 01-22-2013 09:46 AM |
Mail Merge Question | Songbird4411 | Word | 0 | 10-14-2011 08:23 AM |
Mail Merge Question | DavidW | Word | 0 | 08-25-2010 01:47 PM |