Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2012, 07:20 AM
lvillanueva5 lvillanueva5 is offline How do you mass change "Text to Display" on hyperlinks Windows 7 32bit How do you mass change "Text to Display" on hyperlinks Office 2010 32bit
Novice
How do you mass change "Text to Display" on hyperlinks
 
Join Date: Sep 2012
Posts: 1
lvillanueva5 is on a distinguished road
Default How do you mass change "Text to Display" on hyperlinks

I send out survey emails on a bi-weekly basis which consists of a link in the body of the email that points to our Survey Monkey account.

I have to basically create a mail merge via data from excel into a letter format in Word and then go in an manually change each survey link to display what our company wants the link to be shown as, then copy the body of the letter into an email and send out.

There just has to be a better way to do this. I'm unable to do an email merge directly from Excel or Word because we do not want our survey links to show as http://..... And if I try to do a mass change to Text to Display in Excel before the merge, it doesn't bring over the hyperlink, just the display text.



Does anyone know of a fix?
Reply With Quote
  #2  
Old 09-10-2012, 05:32 PM
macropod's Avatar
macropod macropod is offline How do you mass change "Text to Display" on hyperlinks Windows 7 64bit How do you mass change "Text to Display" on hyperlinks Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,061
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
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.
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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you mass change "Text to Display" on hyperlinks Inserting Text and Hyperlinks DrDOS Excel 2 03-21-2012 03:53 AM
MS Word 2007 Won't Display Text Jess Wunman Word 1 03-06-2012 04:26 PM
How do you mass change "Text to Display" on hyperlinks how to change default browser for Outlook hyperlinks soureel Outlook 1 02-03-2011 07:31 AM
How do you mass change "Text to Display" on hyperlinks Change of recipient/sender display name listlow Outlook 4 01-21-2010 03:54 AM
Change Display Name when printing Lucky7MQ Outlook 0 12-10-2005 10:41 PM


All times are GMT -7. The time now is 07:09 AM.


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