Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-21-2013, 07:28 PM
chay chay is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Mar 2013
Posts: 2
chay is on a distinguished road
Default Mail merge from Excel to Word and include hyperlinks

Hi I am trying to do a mail merge from Excel in to Word. My excel document contains a column of different product names and each product name is hyperlinked to a specific web address. I know how to add a hyperlink and then include the appropriate mail merge field once I'm in Word, but my problem is that after I complete my merge, all of the links are exactly the same as the link initially used when inserting the hyperlink in Word. How can I do a merge in to Word and also pull over all of the various links??

THANKS!
Reply With Quote
  #2  
Old 03-21-2013, 10:46 PM
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 8,453
macropod has a spectacular aura aboutmacropod has a spectacular aura aboutmacropod has a spectacular aura about
Default

Hi chay,

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 (though the actual links should go to the correct address after you update the document's fields). 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
  #3  
Old 03-22-2013, 07:26 AM
chay chay is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Mar 2013
Posts: 2
chay is on a distinguished road
Default

That did not work. One of two things happened....either nothing linked, or all of the links were the exact same. I am using Word 2013. Does that matter? Perhaps step by step screen shots would help.

Thanks!
Reply With Quote
  #4  
Old 03-22-2013, 08:19 AM
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 8,453
macropod has a spectacular aura aboutmacropod has a spectacular aura aboutmacropod has a spectacular aura about
Default

Try it with just steps 1-4. It's possible Word 2013 has reverted to the old behaviour.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 06-20-2013, 09:57 AM
askking askking is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jun 2013
Posts: 1
askking is on a distinguished road
Default Mail merge with hyperlinks

Paul,

I know you are tired of answering these mailmerge with different hyperlinks questions, but I've tried everything I could find in the forums with no luck.

I tried inserting a hyperlink, showing the code, and inserting the mergefield name (send_link). The result looks like this:

{ HYPERLINK Send_Link }

After the merge, the originally posted hyperlink comes up for all of the letters.

Can you help?

Thank you very much,

Shea
Reply With Quote
  #6  
Old 09-28-2013, 01:16 AM
macropod macropod is online now Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 8,453
macropod has a spectacular aura aboutmacropod has a spectacular aura aboutmacropod has a spectacular aura about
Default

Hi Shea,

I've been OS for 3˝ months, hence the delay in replying. Have you resolved the issue, or do you still need help?

FWIW, your process description suggests you haven't followed the directions I posted - your modified hyperlink field should have looked like:
{HYPERLINK «Send_Link»}
or:
{HYPERLINK {MERGEFIELD Send_Link}}
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2010 and Excel 2010 Mail merge - multiple headers robby Word 3 04-18-2012 06:37 PM
Mail Merge from Excel Kieroncsmith Mail Merge 2 02-16-2012 09:35 PM
Word mail merge from a protected Excel worksheet Platform Mail Merge 10 09-28-2011 05:12 AM
Excel 2007 to Word 2007 Labels mail merge not working rec Mail Merge 0 07-31-2010 10:45 AM
Help with switches: Word mail merge with Excel ks_ Mail Merge 0 12-09-2009 04:09 PM


All times are GMT -7. The time now is 03:10 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft