#1
|
|||
|
|||
Hyperlink Word Doc Mail Merge
I am using Windows 8 and Word 10. I created a document with a hyperlink. When I hover over the click here I can open Ctrl Click and open without an issue, however, after I do a mail merge the email recipients are unable to open. When they do it pop up says cannot find file. Suggestions PLEASE. |
#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. Finally, 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 |
Inserting an Email Address with hyperlink into a Mail Merge Letter | AClaborn | Mail Merge | 3 | 10-15-2013 04:02 PM |
Mail Merge Word Doc over SSL VPN | David92595 | Word | 0 | 08-23-2013 03:42 PM |
Mail merge with a hyperlink for multiple recipient with different url's? | prkk.06 | Mail Merge | 6 | 05-01-2013 06:42 AM |
I need MS Word Mail Merge Help! | mikecincotta | Mail Merge | 1 | 10-04-2010 05:22 PM |
mail merge in word help | jngovols | Mail Merge | 0 | 04-07-2008 05:40 AM |