Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2012, 04:54 AM
bro4dhead bro4dhead is offline Merging in hyperlinks Windows XP Merging in hyperlinks Office 2007
Novice
Merging in hyperlinks
 
Join Date: Apr 2012
Posts: 6
bro4dhead is on a distinguished road
Default Merging in hyperlinks

Hi there

New to the forum so thanks for any help!

I am looking to send out an email merge from a word document with a "click here" link in the body of the text.

What I am wondering is if it possible to keep the click text the same but merge a different hyperlink in so I can monitor who clicks on it?



Thanks,

Ben
Reply With Quote
  #2  
Old 04-27-2012, 02:24 AM
macropod's Avatar
macropod macropod is offline Merging in hyperlinks Windows 7 64bit Merging in hyperlinks Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Hi Ben,

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-27-2012, 04:02 AM
bro4dhead bro4dhead is offline Merging in hyperlinks Windows XP Merging in hyperlinks Office 2007
Novice
Merging in hyperlinks
 
Join Date: Apr 2012
Posts: 6
bro4dhead is on a distinguished road
Default

Hi Paul

Thanks for the reply.

I have followed your instruction but the hyperlink does not change.

Is there something else I need to make the new hyperlink merge in?

Thanks,

Ben
Reply With Quote
  #4  
Old 04-27-2012, 05:21 AM
macropod's Avatar
macropod macropod is offline Merging in hyperlinks Windows 7 64bit Merging in hyperlinks Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Hi Ben,

Did you execute your mailmerge? If you did, I suggest you try re-doing the field construction. The only thing that doesn't change if you do it right is the 'Click Here' text.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging in hyperlinks merging whole documents? the_adam Mail Merge 5 02-07-2012 03:29 PM
Merging in hyperlinks Merging multiple .txt's Bartestokles Word 5 12-29-2010 01:42 PM
Merging or Cut and Paste AnnieM Word 1 06-24-2010 03:03 AM
Help with merging? yazakib Mail Merge 0 04-11-2010 01:24 PM
Merging documents Stattovic Word 7 01-31-2010 03:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:49 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