Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2014, 12:45 PM
annie* annie* is offline Hyperlink Word Doc Mail Merge Windows XP Hyperlink Word Doc Mail Merge Office 2010 64bit
Novice
Hyperlink Word Doc Mail Merge
 
Join Date: Jan 2014
Posts: 2
annie* is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 01-18-2014, 12:38 AM
macropod's Avatar
macropod macropod is offline Hyperlink Word Doc Mail Merge Windows 7 32bit Hyperlink Word Doc Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink Word Doc Mail Merge 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
Hyperlink Word Doc Mail Merge 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft